By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,968 Members | 1,871 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,968 IT Pros & Developers. It's quick & easy.

TransferSpreadsheet Import Errors

P: n/a
I'm using TransferSpreadsheet to import an Excel file in to MS Access
2003.

DoCmd.TransferSpreadsheet acImport, 8, strTable, strFileName, True, ""

One of the columns in the Excel file is a number formatted field, but
occasionally a cell in that column will not have a value.

When that happens, the code is not returning an error, but I end up
with a table of the Import Errors where that blank field value could
not be imported.

Does anyone know how to to get TransferSpreadsheet to allow these
blank cells and not give me the import error tables?
Sep 5 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
ARC
Look at the design of the table that the spreadsheet is being imported into.
In the column in question, check the settings for "Required" and "Allow zero
length", as these may not be set properly.

Hope this helps,

"Icarus" <tj******@gmail.comwrote in message
news:58**********************************@34g2000h sh.googlegroups.com...
I'm using TransferSpreadsheet to import an Excel file in to MS Access
2003.

DoCmd.TransferSpreadsheet acImport, 8, strTable, strFileName, True, ""

One of the columns in the Excel file is a number formatted field, but
occasionally a cell in that column will not have a value.

When that happens, the code is not returning an error, but I end up
with a table of the Import Errors where that blank field value could
not be imported.

Does anyone know how to to get TransferSpreadsheet to allow these
blank cells and not give me the import error tables?
Sep 5 '08 #2

P: n/a
On Sep 5, 10:26*am, "ARC" <PCES...@PCESoft.invalidwrote:
Look at the design of the table that the spreadsheet is being imported into.
In the column in question, check the settings for "Required" and "Allow zero
length", as these may not be set properly.

Hope this helps,

"Icarus" <tjmos...@gmail.comwrote in message

news:58**********************************@34g2000h sh.googlegroups.com...
I'm using TransferSpreadsheet to import an Excel file in to MS Access
2003.
DoCmd.TransferSpreadsheet acImport, 8, strTable, strFileName, True, ""
One of the columns in the Excel file is a number formatted field, but
occasionally a cell in that column will not have a value.
When that happens, the code is not returning an error, but I end up
with a table of the Import Errors where that blank field value could
not be imported.
Does anyone know how to to get TransferSpreadsheet to allow these
blank cells and not give me the import error tables?- Hide quoted text -

- Show quoted text -
The TransferSpreadsheet is creating the table that it is importing
into. Can I change the field properties as part of
TransferSpreadsheet?
Sep 5 '08 #3

P: n/a
ARC
The way I have mine set up is that I have a table that I specify in the
transferspreadsheet statement. I match up the column headinigs of the xls to
the table, where I can define table properties, such as the required
property:

DoCmd.TransferSpreadsheet acImport, 8, "ImportParts", strFileImport, true

So my temp table for holding the import already exists and is named
"ImportParts".

Hope this helps,

"Icarus" <tj******@gmail.comwrote in message
news:a8**********************************@8g2000hs e.googlegroups.com...
On Sep 5, 10:26 am, "ARC" <PCES...@PCESoft.invalidwrote:
Look at the design of the table that the spreadsheet is being imported
into.
In the column in question, check the settings for "Required" and "Allow
zero
length", as these may not be set properly.

Hope this helps,

"Icarus" <tjmos...@gmail.comwrote in message

news:58**********************************@34g2000h sh.googlegroups.com...
I'm using TransferSpreadsheet to import an Excel file in to MS Access
2003.
DoCmd.TransferSpreadsheet acImport, 8, strTable, strFileName, True, ""
One of the columns in the Excel file is a number formatted field, but
occasionally a cell in that column will not have a value.
When that happens, the code is not returning an error, but I end up
with a table of the Import Errors where that blank field value could
not be imported.
Does anyone know how to to get TransferSpreadsheet to allow these
blank cells and not give me the import error tables?- Hide quoted text -

- Show quoted text -
The TransferSpreadsheet is creating the table that it is importing
into. Can I change the field properties as part of
TransferSpreadsheet?

Sep 5 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.