Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing variable length text files

Status
Not open for further replies.

scottshiv

MIS
Sep 13, 2002
47
US
I am running Access 2003.

How do I import a variable length text file? The fixed part of the record contains demographic information and the variable part is a two character type program field and two date fields.

Thank you.
 
Access is setup to import fixed width files and Delimited files. You can specify just about any delimiter but tabs and commas are probably the more common.

Does that help? If not, can you provide more information, maybe a sample of what variable lenght you are seeing?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top