Refreshing Data Daily From a Linked Excel Spreadsheet

  • Thread starter Thread starter Brad
  • Start date Start date
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
Click to expand...
 
Back
Top