K
Kamil
Hi.
I have an Access database for financial reports (actuals,
budgets, ...).
The data is uploaded from excel sheets (all validations are done in
excel sheets). One report contains about 10 sheets of data to be
uploaded to different access tables. It's about 300 rows and 50
columns in each sheet.
What is the most effective method to upload that amounts of data?
These sheets are not ready to be directly uploaded to Access, I need
to select specific columns to upload).
Now I'm just creating INSERT INTO statement for each cell and
executing it (using ADO).
I'm wondering if there is a better method, like working on recordsets
or temporary excel sheets (uploading whole table at once).
The current solution is too slow.
In addition - when someone else tries to upload some other data at the
same time, both uploads are frozen for several minutes... (the
database is saved on the network share).
Do you have any advice for such case?
Thanks
Best regards,
Kamil
I have an Access database for financial reports (actuals,
budgets, ...).
The data is uploaded from excel sheets (all validations are done in
excel sheets). One report contains about 10 sheets of data to be
uploaded to different access tables. It's about 300 rows and 50
columns in each sheet.
What is the most effective method to upload that amounts of data?
These sheets are not ready to be directly uploaded to Access, I need
to select specific columns to upload).
Now I'm just creating INSERT INTO statement for each cell and
executing it (using ADO).
I'm wondering if there is a better method, like working on recordsets
or temporary excel sheets (uploading whole table at once).
The current solution is too slow.
In addition - when someone else tries to upload some other data at the
same time, both uploads are frozen for several minutes... (the
database is saved on the network share).
Do you have any advice for such case?
Thanks
Best regards,
Kamil