Importing excel data into separate (but linked) Access tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an application that contains a number of linked tables (As an example
of the type of links I have, the main "properties" table contains rental
property addresses and data, along with the owner's info. But since an owner
may have several properties, the owner data is stored in a separate "owners"
table, and the properties table just has a field linked to a primary index
key in the owners database).

The application uses a form to allow users to enter or edit the individual
records. Since I have more than one table, the form's data source is a query
with the relevant records from each table.

I want to allow users to import some data into these tables from an excel
spreadsheet. I have some understanding of the TransferSpreadsheet action, but
I am not sure how to import the data in Excel directly into the two separate
tables. Can TransferSpreadSheet import into more than one table? Or should I
import into a query? If I use a query, would the same query used for the form
work for this as well? (the excel table would contain exactly the same fields
entered by a user in the form).

If you need any more info please let me know. Any help will be appreciated!

Thanks,

William
 
If the Excel sheets are already linked, then you don't really need to use the
TransferSpreadsheet. The two solutions that come to mind immediately are to
either write VBA code to put the data from the Excel sheet into the two
tables or to write two append/update queries (whichever are applicable) to
use the Excel sheet as the source, and write the data to the destination
tables.
 
Back
Top