Ron Moore
rmoore at comtechpst.com
Tue Dec 9 11:23:52 CST 2003
Oleg, you ask how to save from XL and then list steps to import into XL. Have you tried <File>,<Save As>? Then look at .csv, tab delimited, space delimited, etc. HTH Ron Moore Sr. Database Administrator Comtech PST Corp. www.comtechpst.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Oleg_123 at xuppa.com Sent: Tuesday, December 09, 2003 12:11 PM To: accessd at databaseadvisors.com Subject: [AccessD] (OT) Excel Ascii file Sorry to post this again; but I accidentally deleted all my messages, and dunno if anyone answered it.. :-(( Hey Group, how do I save Excel document as an ascii file with positions ? (meaning col1 - 00-002, col2 003-008, col3 009-017) etc. I found this on the internet -- am not quite sure whether its related, but in any case i can't seem to find "Original Data Type section" ---------- Fixed Width Text Import Wizard - Step 1 Opening an ASCII text file in Excel will probably result in display of the Text Import Wizard dialog box. 7. In the Original Data Type section, choose the Fixed Width radio button if Excel has not already done that for you. 8. If you want to skip rows at the beginning of your file, set the first row containing actual data with the Start Import at Row option. To conclude Step 1, click the Next button. Fixed Width Text Import Wizard - Step 2 You need to define the field widths for Excel. The instructions for creating field divisions are shown directly above the Data Preview area. 9. Position the mouse pointer on the ruler at the transition between fields and click the left mouse button. Repeat this procedure for each field. If the total record length is wider than the Text Import Wizard window, click the horizontal scroll bar to see the rest of your data. When all fields have been defined, click the Next button ----------------------------------------- Get Breaking News from CNN, ABC, NBC, CBS Now. http://www.xuppa.com/news/?link=webmail _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com