View Single Post
  #2 (permalink)  
Old September 10th, 2004, 05:22 PM
jmaronilla jmaronilla is offline
Friend of Wrox
 
Join Date: Jul 2003
Location: South San Francisco, CA, USA.
Posts: 128
Thanks: 0
Thanked 1 Time in 1 Post
Default

What application will you be using excel or access?
if you will be using excel:
1. Open file with Excel for windows.
2. Click on the first column heading. This will hightlight the first column of the spreadsheet.
3. From the File menu select Data --> Text to Columns...
4. Choose Delimited and next.
5. Check tab, comma or however it fits you.
6. Your datas should now have diff. columns.
7. Select finish.

if you will be using access:
1. Open access app.
2. Select File --> Get external data --> import
3. Select the textfile.
4. continue

Hope this helps.
John


Reply With Quote