J
Jay
Hi,
I'm using a Access 97 to export a query with the transferspreadsheet command:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97,
"qryCBGandPendingReclaims", Destination & FileName
I think the limit to the destination path (Destination & Filename) is 64
characters? Can anyone confirm that this 64 character limit is only in Access
97? and if there's a way around it?
I know Access2000 exceeds this limit , but this database needs to be run on
A97.
Thanks,
Jay
I'm using a Access 97 to export a query with the transferspreadsheet command:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97,
"qryCBGandPendingReclaims", Destination & FileName
I think the limit to the destination path (Destination & Filename) is 64
characters? Can anyone confirm that this 64 character limit is only in Access
97? and if there's a way around it?
I know Access2000 exceeds this limit , but this database needs to be run on
A97.
Thanks,
Jay