Connecting Tech Pros Worldwide Forums | Help | Site Map

Duplicate tab delimited text file

Dixie
Guest
 
Posts: n/a
#1: Nov 13 '05
I have a copy of a tab delimited text file that was created from an excel
spreadsheet. I want to try to emulate this text file using Access 2000. I
don't have access to the spreadsheet, but do have a copy of one of the tab
delimited text files. I can emulate all the fields in it, but there are
things like multiple tabs between some fields. For example, at once stage,
there are 35 tabs in a row - can see that be simply moving the cursor.
There are also obviously some carriage returns in it to force a new line.
Is there any way I can duplicate this?



asn
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Duplicate tab delimited text file


This is could be a primitive way. But you could try this
If you have a spreadsheet program like excel. Try to import this text
file using data->get external data->import text file.
Step 2 of the import text wizard has an option (check box) treat
consecutive delimiters as one. Use it to remove your tabs and save the
file
Probably taking the data then to access will be quiet easy

Closed Thread