Linking to exported tables and queries

[Stephanie]

Hello,

I have office XP. The issue that I am having is when I
export a table from Access to Excel (and I'm usually
copying over an old file because it's a monthly macro). I
have an Excel file that links to the exported table. If I
try opening up the file with the links without opening the
exported table first I get an error "Unable to read file"
but if I open the file with the exported table first it's
okay. How do I fix that? Thanks.

 

[Debra Dalgleish]

Instead of using the File>Export command in Access, try using the
TransferSpreadsheet, to export the table to an existing workbook.

You can write code, or select the command in an Access macro.

The first time you run the code/macro, it will create a new sheet.