date export from excel - alphanumeric value problems

[GetReel]

Hi there. I hope I have posted my question in the right section.

I worked out how to import data into access but I am coming across a small problem.

I have function the imports all the data and the heading from the excel sheet in an existing table. This works well except doesnt like certail values being imported. The problem is restricted to only on column. Here a sample data from the spreadsheet that are having problems being imported. In case you need to know, the data type for all the fields in the access tblMain are text.

Movement Date PassNo

D 23/01/2008 10:04 9922018081
D 5/01/2008 7:00 9946016032
A 19/01/2008 21:57 9962028145
A 4/01/2008 11:36 003803A
A 6/01/2008 7:34 00AE22628
D 16/01/2008 21:40 00AE22628


Where there is an Alpa and a numberic (ie 003803A) it doesnt seem to handle the import too well. I get blank values in the access table. Is there anything that I can do?

 

[namliam]

You are refering to the PassNO right??

The problem comes from the fact that Access is trying to do the thinking for you, but... it thinks because the first few are number only, that it are numbers, instead of tekst.

Otpions:
- Format the column in Excel to "Text"
- Make sure a text value is in the first "few" or is the first value
- Export from excel to CSV and import the CSV, Access can be navigated much more precisely when importing a CSV.

Non of the solutions are perfect... sorry...

 

[GetReel]

Thanks for that but it didnt work.

 

[s1police]

I assume you are not using the wizard bcoz you said you have a function....
You write the function to import data, right? Please post your coding first and let us see.

Thank you.
Victor

 

[namliam]

Thanks for that but it didnt work.

Well then.... I think it should, but if it doesnt... I am sure fresh out of ideas

 

[GetReel]

Ive got it working. It was no of records being imported and exported that was the issue.