Saving Import Specs

[Aidy680]

Is it not possible to save the import spec of an Excel file?

The advanced button isnt displayed when I try to do so yet if I re-save it as a .csv then it suddenly appears. Bizarre!

Thanks.

 

[Aidy680]

anyone...please....!

 

[Remou]

In my version of Access, there are no import specs for Excel. Anything you want to set is set in Excel itself. What did you wish to do?

 

[Aidy680]

I'm just trying to save the import spec of an Excel file I import on a regular basis.

With .csv files the "Advanced" button appears on the import dialogue; not so with Excel spreadsheets.....

 

[Remou]

I meant, why do you wish to save the import specification? Have you looked at TransferSpreadsheet?

 

[Aidy680]

Thanks Remou you're quite right.

I'm aware of that command but I wrongly thought that I would have to specify a spec name and that's not the case.

TransferSpreadsheet will do fine.