Access 97

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

How to convert a table into a flat file. I need to upload
to another file, but it must be a flat file.
 
Julie said:
How to convert a table into a flat file. I need to upload
to another file, but it must be a flat file.
Click to expand...

A single table is a flat file, but if you have fields which are foreign keys
to other tables, you'll need to write a query including all those tables
with the value(s) that the foreign key is/are describing. Then a Make Table
Query will give you the flat file you are looking for.

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
How to convert a table into a flat file. I need to upload
to another file, but it must be a flat file.
Click to expand...

File... Export, and select the option to export as text.
 
Back
Top