Linking an Excel Spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try going into the advanced options when linking. You
should be able to change the Field Names in there.
 
Hi Tfitz,

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