Linking an Excel Spreadsheet

T

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
 
G

Guest

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

John Nurick

Hi Tfitz,

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