Ron Moore
rmoore at comtechpst.com
Tue Dec 9 14:37:45 CST 2003
Oleg, I may have misunderstood your original post. You may want to check these out, particularly the first one, which uses access. http://www.regents.state.oh.us/hei/1-1users2000.pdf http://www.uno.edu/~ucc/howto/misc/editors/Fixed-width.htm 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 1:10 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] (OT) Excel Ascii file yeah, i see know to save it as .csv, but i don't see where to type the positions, beause I was given positions of each column -- 001-002, 003-008, 009-017, etc. > 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 > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com ----------------------------------------- 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