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?

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" <tjmoses1@gmail.comwrote in message
news:58b259b0-442c-4730-b5b2-77e49589f2d3@34g2000hsh.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?

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:58b259b0-442c-4730-b5b2-77e49589f2d3@34g2000hsh.googlegroups.com...
>
>
>

>

>

>

>

>
- Show quoted text -

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

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" <tjmoses1@gmail.comwrote in message
news:a89c3595-b09a-4fea-8a48-f0de1e23c930@8g2000hse.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:58b259b0-442c-4730-b5b2-77e49589f2d3@34g2000hsh.googlegroups.com...
>
>
>

>

>

>

>

>
- Show quoted text -

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