View Full Version : Importing Txt Files into Access


peckitt99
02-05-2008, 03:06 AM
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
02-05-2008, 03:52 AM
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.