Automatically copy data from a Linked XLS to a table

[charliemopps]

So we have a large Oracal DB that is going to do some rather complex data crunching and dump a report in an XLS format into a network drive every 30min.

I am tasked to build an Access DB that can then look at that data and present it in a more readable form.

The first, and most annoying problem I've run into is that Access will not let me name the collums in the linked table. I think the best way to solve this problem would be an update querry. I, however, can not seem to get the querry to copy the data to the table.

Does anyone know how I can easilly, and automatically, move all the data from one linked XLS spreadsheet to an Access table?

Thanks!

 

[DCrake]

Simply create the destination table with the correct field names. Then create an append query and map the linked xls file to the coressponding fields in your target table. Then run the append query.

 

[charliemopps]

OH... I have to link the fields? ah... I didn't do that. I will try it out.