Import data from one spreadsheet to populate multiple tables

[Ray67]

Hello
Need help!!!!! I just got a report build to run data based on date of transactions. The reports give me any transaction that happens within a month.
The report has about 120 columns of data. I would like to populate all of this data into 4 tables.
Here are the tables Patient Demo, patient visits, payments and adjustments. One of my biggest issues would be file size limit.


I would like to import the spreadsheet to one table than within access populate the data into all four tables. Only import the data when there's been a change.

Thank you

[June7]

You have an Excel spreadsheet with patient info that needs to be imported into 4 Access tables but only the data that has changed? How will you know data is changed?

What does report have to do with this?

[Ray67]

i know data changed if there are new patient on the report but not in access. Not sure about your questions (What does report have to do with this?)

[June7]

You started post by describing a report you built then state "I would like to populate all of this data into 4 tables". If you have the report, where is it's data presently coming from?

If you want only new patients from the worksheet, do a FindUnmatched query that compares records in the linked Excel and the PatientDemo table.

Google: append unmatched records
http://www.ozgrid.com/forum/showthread.php?t=47074

[Ray67]

Thank you i will look into that website.