Change link to Excel Spreadsheet (1 Viewer)

[JDAccess3000]

Hello,

I've inherited an access database which is fed data from an excel spreadsheet, however I would like to change the feeding file to a new excel spreadsheet with added columns from what I already had. Would it be best to add the new columns into the original file (what affect would this have) or should I change the linked file. Is anyone able to advise how to do this?

Thanks

 

[arnelgp]

you need to Import the new Excel as Linked table.