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 im****t functionality of the TransferSpreadsheet
macro
as part of an autoexec macro.
To create my Excel do***ent, I'm ex****ting data from a financial system
and
using the im****t 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:
im****t
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 im****t 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 im****t without
field
names to append a table as long as the fields are in the same order.
These
are... any ideas?
