Saving data in a database format

Saving data in a database format

Post by charle » Fri, 02 Nov 2007 17:50:05


I have text data in a simple "table format".

I would like to write the data to a (new) file with an ".mdb" extension
and for this file to open in MS Access.

Is there a "simple" text file format that would work, or,
can anyone advise me the best (simplest) way to do this.


Thanks

CharlesW
 
 
 

Saving data in a database format

Post by Norm Coo » Fri, 02 Nov 2007 21:11:02


Open Access, open a new or existing DB, then
File|Get External Data|Import.

Then when prompted, select Files Of Type -- Text Files

You will get a wizard which will help you format the fields
and create a table from the data.