YET ANOTHER transferSpreadsheet dilemma...

[David]

Hello!

I'm trying to export the contents of some tables to Excel. The code works in
Access 2000, but seems to fail in 97:

Dim templateDir, reportDir, archiveDir

'Archive Location
archiveDir = "D:\Inventory DB\Live Version\Archive"

'Template Location
templateDir = "D:\Inventory DB\Live Version\Template"
templateName = "Critical Items Report Format.xls"


DoCmd.TransferSpreadsheet acExport, acspreadsheettypeexcel1997, "DATASET_1",
archiveDir, True
DoCmd.TransferSpreadsheet acExport, acspreadsheettypeexcel1997, "DATASET_1",
templateDir & "\" & templateName, True
DoCmd.TransferSpreadsheet acExport, acspreadsheettypeexcel1997, "RESULTS",
templateDir & "\" & templateName, True

On execution, this always yields a '3190: Too many Fields' error on the
third transferSpreadsheet call, but there's only 11 fields, and not a great
deal of records. Why onlt the last field?? I'm rather lost...

I've searched some of the other threads (and google groups), and apart from
suggestions to change the spreadsheet type (I tried acspreadsheettypeexcel8),
I'm rather lacking in ideas. I've also tried compact and repair.

Any thoughts??

Any suggestions appreciated, as always!

Best,
David

 

[David]

Apologies! Problem solved. It was a template versioning error. Not *my* fault.