Import from Text File , Export later

[soldat452002]

Hello,

My Text File has header fields like this:

"ProducerId"|"BusinessUnits"|"DateEff"|"DateExp"|"Extra"|

The data values are separated by | into a web database. For Example:

"001"|"Any"|"01012015"|"01312015"||

Question is I need to create several access tables by importing this format, then exporting out. How can I achieve this in Access?

 

[Ranman256]

Import 1 manually, and set the delimiter, then save the spec.
From then on, use docmd.transfertext