M
Mike
I am trying to import data from an Excel file to Access
table by using an append query (Excel file is linked to
database).
Everything is going right except one column ("Index"
column).
In Excel this column contains numbers from 1 To 9999 and
sometimes a letter + 2 digits (like D32), like this:
_____________________________________
Amount Name Index
-------------------------------------
152.00 John 1564
356.00 Nick 149
564.00 Ann D32
654.00 Elen H96
______________________________________
"Index" field properties in Access table are: Text;
maximum 15 characters; no any restrictions; no masks;
allow zero length. The table is not in relation with other
tables.
So, after the import process is finished I do not get any
error messages. All the records are imported. But in that
very column the number-values (like "1564" and "149")are
there and letter-values (like "D32" and "H96") are not
(just empty cell).
What is wrong? Any ideas?
table by using an append query (Excel file is linked to
database).
Everything is going right except one column ("Index"
column).
In Excel this column contains numbers from 1 To 9999 and
sometimes a letter + 2 digits (like D32), like this:
_____________________________________
Amount Name Index
-------------------------------------
152.00 John 1564
356.00 Nick 149
564.00 Ann D32
654.00 Elen H96
______________________________________
"Index" field properties in Access table are: Text;
maximum 15 characters; no any restrictions; no masks;
allow zero length. The table is not in relation with other
tables.
So, after the import process is finished I do not get any
error messages. All the records are imported. But in that
very column the number-values (like "1564" and "149")are
there and letter-values (like "D32" and "H96") are not
(just empty cell).
What is wrong? Any ideas?