Auto load table

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

Guest

Is it possible to automatically load a table with data from a csv or excel
file?

I want to automate a data entry process. Everday I recieve an excel
spreadsheet containing data that I have to manually insert into a table. I
would like to create a function macro that will grab the file from a
specified location and automatically upload the file into my database. Can
anyone help? Any ideas?
 
I don't know if this is the most efficient way, but what I do is create a
transfer text macro that brings the data into a holding table and then runs
an append query to load the data in the holding table into the main table.
The third step is to also have a delete query step to empty out the holding
table.

This worked for me. It only takes about 2 seconds to import hundreds of
records a day.
 
Interesting approach. Thanks for the insight.

AmandaM said:
I don't know if this is the most efficient way, but what I do is create a
transfer text macro that brings the data into a holding table and then runs
an append query to load the data in the holding table into the main table.
The third step is to also have a delete query step to empty out the holding
table.

This worked for me. It only takes about 2 seconds to import hundreds of
records a day.
Click to expand...
 
Hi. I was reading your response and I had a similar approach to this problem
but my append query only worked to update existing records in the main table.
When there were new records in the holding table I get an error related to
having a null in the key field of the main field. What am I doing wrong?
Thanks.

Steve
 
Hi,

I also have the same problem. I too get a file in excel and that i need to
upload it into access. Amanda, your solution looks interesting but sad part
is i dont know how to create the macro which you have said. Can you help me?
 
Back
Top