MS Access Import from TXT file

[ChrisK]

Hi,

I want to import data from a text file (1 column, line seperated) and have it imported as each table.

Example:
The DB name is Ontario. In the text file I have a listing of cities in Ontario. I want to have each city as a different table.

The default setting in Access will only allow me to take the text file data and add i to a single table.

I know that I can split the text file into multiple files...but that would be more work then its worth.

Any help would be great on this matter.

Thanks!

[Angre Nichols]

Post the file and maybe I can help more.

Why do you want each city to be it's own table?

[TPS]

One way, especially if you want to add additional data fields later is to make a new database.

From Acess start a new database by opening up your text file.
Then follow the requests on the " LINK TEXT WIZARD"
Save this as your new database for the new input data.
Can be saved as a MS database or MS Excel.

Now, when your in the "DESIGN" mode of your existing Ontario database, you can import data from the new database or Excel file.