Reading a .txt file using Access

[StevenJ]

Here's my situation. I have a .txt file that I need to bring into Access. This .txt file is set up with records that are separated by semicolons.

I need to pull this information into Access and separate the data by the semicolons. I can open the file in Excel and separate the information by using Data --> Text to Columns --> semicolon (as the separator).

Does anyone have an idea how I can do this into Access.

 

[llkhoutx]

Take at look at the Access Help Wizard using "import delimited text". You'll find the answer.

 

[ecniv]

Or write a decent bit of Vba Code