TransferSpreadsheet inserts extra rows on export (bug?)

  • Thread starter Thread starter strict9
  • Start date Start date
S

strict9

Hello all,

I have some VBA code with the following line:

DoCmd.TransferSpreadsheet acExport, , "Test", ExportPath, True,
"Agency!"

However whenever this runs, it shows up in the spreadsheet as:

A1 Field Name
A2
A3 Data
A4 Data
A5 Data

In other words, row A2 is skipped. This causes a problem as the data is
sent to a conversion server.

Any idea what is causing this? I've tried creating both a new
spreadsheet and a new table to export from. I've also tried changing
the parameters in the transferspreadsheet method, specifically the
True->False and also specifying the row range to export to. Neither
work, and also the documentation states both aren't used during export
anyway.

Any ideas? Thanks!
 
Is there a blank record (i.e. with all fields containing Nulls or
zero-length strings) in the table or query you're exporting?
 
Back
Top