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.
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.