Refreshing Data Daily From a Linked Excel Spreadsheet

B

Brad

We have an Access 2007 application that pulls certain fields from a linked
Excel spreadsheet into an internal Access table on a daily basis.

The current process is to delete all of the rows in the internal Access
table and then use a query to append the selected data from the linked Excel
spreadsheet into the internal table.

Is there a better way to do this?

Can this be done in one step? (delete old data and refresh the table with
new data)

The field names in the Excel spreadsheet are different than the field names
in the internal table (and in the VBA code). The Append Query works nicely
for making this transition, but we have wondered if there is a better way to
handle this.

Thanks,
Brad
 
Ç

çÏÒÌÁÎÏ×Á

Brad said:
We have an Access 2007 application that pulls certain fields from a linked
Excel spreadsheet into an internal Access table on a daily basis.

The current process is to delete all of the rows in the internal Access
table and then use a query to append the selected data from the linked
Excel
spreadsheet into the internal table.

Is there a better way to do this?

Can this be done in one step? (delete old data and refresh the table with
new data)

The field names in the Excel spreadsheet are different than the field
names
in the internal table (and in the VBA code). The Append Query works
nicely
for making this transition, but we have wondered if there is a better way
to
handle this.

Thanks,
Brad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top