Linking an Excel Spreadsheet

[Tfitz]

I wnat to automatically link a specified excel spreadsheet and not have the
first row be the field descriptions. I have the automatic link part figured
out, but it always wants to take the first row as the field names. If I use
the wizard, I can select not to use the first row as field names. I'm using
access97

 

[Guest]

Try going into the advanced options when linking. You
should be able to change the Field Names in there.

 

[John Nurick]

Hi Tfitz,

DoCmd.TransferSpreadsheet has a HasFieldNames argument; this should be
False.