A
adodson
FYI - I'm using Office 2007 saving my Excel files in the 2003 format. The
Access database I'm working with is in 2000 format.
I'm attempting to use import functionality of the TransferSpreadsheet macro
as part of an autoexec macro.
To create my Excel document, I'm exporting data from a financial system and
using the import wizard. I'm allowing all of the fields to default to
general format. However, I've also tested using Text & Currency formats.
The settings I'm using for the TransferSpreadsheet macro are:
import
Microsoft Excel 97 - Excel 2003 Workbook
XCSH1
C:\tempdl\xcsh1.xls
No (field names)
My table fields are formatted as Number or Text.
Problem: I can get the table to import with the field names entered, but it
keeps giving me an error about fields not existing if I have the field name
setting set to no.
Reading the help file, I think that I should be able to import without field
names to append a table as long as the fields are in the same order. These
are... any ideas?
Access database I'm working with is in 2000 format.
I'm attempting to use import functionality of the TransferSpreadsheet macro
as part of an autoexec macro.
To create my Excel document, I'm exporting data from a financial system and
using the import wizard. I'm allowing all of the fields to default to
general format. However, I've also tested using Text & Currency formats.
The settings I'm using for the TransferSpreadsheet macro are:
import
Microsoft Excel 97 - Excel 2003 Workbook
XCSH1
C:\tempdl\xcsh1.xls
No (field names)
My table fields are formatted as Number or Text.
Problem: I can get the table to import with the field names entered, but it
keeps giving me an error about fields not existing if I have the field name
setting set to no.
Reading the help file, I think that I should be able to import without field
names to append a table as long as the fields are in the same order. These
are... any ideas?