P
Paul Ridings
Hi
I'm importing a column of data with a reference number in it from Excel to
Access 2000 using a macro. The first few reference numbers in the excel
sheet are purely numbers but further down I have reference numbers with
letters in them.
After importing the file, all the ref numbers with letters in are blank in
the table. I'm assuming the import is seeing the numbers on the first row
and creating a numeric field. I've tried creating a table before importing
with a field type text and also tried changing the cell type to text in
excel without much luck.
Any help would be appreciated.
Thanks
Paul
I'm importing a column of data with a reference number in it from Excel to
Access 2000 using a macro. The first few reference numbers in the excel
sheet are purely numbers but further down I have reference numbers with
letters in them.
After importing the file, all the ref numbers with letters in are blank in
the table. I'm assuming the import is seeing the numbers on the first row
and creating a numeric field. I've tried creating a table before importing
with a field type text and also tried changing the cell type to text in
excel without much luck.
Any help would be appreciated.
Thanks
Paul