Mapping to existing table

  • Thread starter Thread starter FredS
  • Start date Start date
F

FredS

This must be a common issue, but I'm stumped. I have
written a trial 3-table relational database in Access
with queries and reports. Now I want to "map" existing
data from an ASCII source (mainframe pullfile). The
other databases I use have a simple "Import" with mapping
data function.

In Access, when I "Import" the data I end up with a new
table! This is unacceptable, because my reports,
queries, etc. don't work, of course, on the new table.

I can find no reference anywhere to "mapping data" into
an existing table.

Can anyone please help??? A simple import does NOT work.

Thank you
Fred
 
Fred,

Hmmm. I would have thought that importing from anything except another
Access database, you have the choice of using a new table or existing table.

Anyway, you can use an Append Query to move the imported data into the
table where you want it.
 
Back
Top