transefing data from excel to access

[jancho]

Hi!

I just need a little help finding out how to display the numbers that i import from excel with 0 in the front. Example: i got a number 00000023456 and it only displays 23456 and that is why i have duplicate values.

Thanks,
J

[Stwange]

Hi!

I just need a little help finding out how to display the numbers that i import from excel with 0 in the front. Example: i got a number 00000023456 and it only displays 23456 and that is why i have duplicate values.

Thanks,
J

Insert a new row at the top of the spreadsheet, and fill the reference field with "test", this will cause access to recognise that field type as text instead of a number, and so the leading zeros will be retained. Once it has imported, simply delete the first (test) record.