transferspreadsheet too many fields, but not with transfer text

  • Thread starter Thread starter eweber
  • Start date Start date
E

eweber

I am using vba to generate a crosstab query which then
outputs to an excell spreadsheet. An intermittenet problem
is that when I use the transferspreadsheet
(acSpreadsheetTypeExcel8), I get the error too many fields
defined (error number 3190). When i use transfertext to
create a comma delimited file (.csv) with the same query,
this doesn't occur.
 
Back
Top