T
theOrphans
I have a table existing in Access, and a matching spreadsheet tab in excel.
Field formats in both files are identical (set to text). Using a macro and
the TransferSpreadsheet function, I have successfully imported the majority
of my data. However, columns in the excel file where there is alpha-numeric
data in columns mixed with only numeric data, or if most cells are empty and
a few in a column have text, they are not being imported into my access
table. They are instead put into a $_ImportErrors table.
I realize the macro is not following the format outlined by the excel file
or the access table when performing the import. Is there any way to
eliminate this type of errors? Or to indicate what format should be followed
in the import for the specific columns?
Field formats in both files are identical (set to text). Using a macro and
the TransferSpreadsheet function, I have successfully imported the majority
of my data. However, columns in the excel file where there is alpha-numeric
data in columns mixed with only numeric data, or if most cells are empty and
a few in a column have text, they are not being imported into my access
table. They are instead put into a $_ImportErrors table.
I realize the macro is not following the format outlined by the excel file
or the access table when performing the import. Is there any way to
eliminate this type of errors? Or to indicate what format should be followed
in the import for the specific columns?