Search results for query: *

sorry for my english. of course i have and i want these 2 columns to be text columns. and i have both set in access and in excel the type of these columns to text. But when i import in access it give me errors in importing, i think this is caused because access try to import them as a number...

sorry... i mean, that the first row have the 2 column value empty, not the row is empty. the fact is that these 2 columns have mainly numeric value, but not only so the non numeric value is about 25 row position... or later..

the problem is that the 2 columns that have import error, are empty at the first line, so if i put ' inside them the table i import has an empty value, and all other field with no value are NULL! :< probably a macro or sub is the way!

Hello, i'm trying to import an excel sheet in an access table. My problem is how to import 2 text column that access always try to import as numeric, and so raise me errore when find out a non numeric value. What i've tryed is: 1) format the excel sheet columns as text. 2) building a table in...