transfer table to excel

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

i would like to transfer a table from access to excel, but
i dont want the field names to be transferred along. Is
there a way to stop these field names?
 
Set the "Has Field Names" argument to No (for TransferText and
TransferSpreadsheet actions).
 
ive tried that and it does not work
-----Original Message-----
Set the "Has Field Names" argument to No (for TransferText and
TransferSpreadsheet actions).

--
Ken Snell
<MS ACCESS MVP>




.
Click to expand...
 
Please post the macro actions that you're running, including the values for
the arguments.
 
Here is info from Help file for the TransferSpreadsheet action:

Has Field Names
Specifies whether the first row of the spreadsheet contains the names of the
fields. If you select Yes, Access uses the names in this row as field names
in the Access table when you import or link the spreadsheet data. If you
select No, Access treats the first row as a normal row of data. The default
is No.
When you export an Access table or select query to a spreadsheet, the field
names are inserted into the first row of the spreadsheet no matter what you
select in this argument.

Note the last sentence. It appears you cannot "turn off" the field names
using TransferSpreadsheet.

You'll need to either use Automation to write the data into the EXCEL
worksheet, or use Automation after the export to delete the first row that
has the field names. Neither of these can be done via a macro; you need to
use VBA code.
 
Back
Top