Importing data that contain NULL values.
Importing data that contain NULL values.
(OP)
Here's an example: I try to import data from Excel,(for example), in which there are NULL values in a column that contains numbers and text. The column is formatted as text in Excel, and as I import in the Access wizard, I try to define the same column as text, but it doesn't allow me - it defines the field as a Double integer.
Are there any special rules for importing data into Access?
Are there any special rules for importing data into Access?
RE: Importing data that contain NULL values.
RE: Importing data that contain NULL values.
The approach I use when there are a large number of named colums is to use the wizard to build the table. It will of course make many of the columns an inappropriate type and have errors all over the place. I then delete everything in the table, correct the types and start over.