How to convert a database in text file forma into Access Database

G

Guest

I've a few database in text file format that contain some millions of records.

All text files are deliminated in "|"

I manage to open them and view the records in access 2007.

I wish to find out what are the steps I need to do to convert all these text
files database into an access 2007 database?

I thank you in advance.
 
J

Joseph Meehan

AccessIssue said:
I've a few database in text file format that contain some millions of
records.

All text files are deliminated in "|"

I manage to open them and view the records in access 2007.

I wish to find out what are the steps I need to do to convert all
these text files database into an access 2007 database?

I thank you in advance.
Click to expand...

You need to import them not open them. Use the File "Get External Data"
choice from the top line menu.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Access database to 97 1
count number of data in one database in a range from another file? 6
date format 1
copying a database in 2007 1
how to convert the bytes to word document in ms access database 1
Import MS Works database to Access 2007 8
Rich Text Question 2
Convert to Access 2007 file format? 1

Top