[AccessD] (OT) Excel Ascii file

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



More information about the AccessD mailing list