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