Linking an Excel Spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tfitz - 06 Jan 2005 16:44 GMT

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

Reply to this Message

- 06 Jan 2005 19:59 GMT

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

>-----Original Message-----
>I wnat to automatically link a specified excel spreadsheet and not have the
[quoted text clipped - 3 lines]
>access97
>.

Reply to this Message

John Nurick - 06 Jan 2005 21:28 GMT

Hi Tfitz,

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

>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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message