Importing Txt Files into Access

[peckitt99]

how do i Import the data from text files so that i can create the database structure?

for example i have 3 files called - data.txt, booking.txt and, other.txt and want them imported into access?

this is because these tables will be holding all the entities etc

Thanks in advance

 

[Dennisk]

try the import wizard. Select import from the menu and select the type of file to import i.e .mdb, .csv, .txt etc and follow the directions.

If there are problems during the import a file will be created containing the errors.