Importing from Excel woes !!

[VegaLA]

Hi all,
I have been using Excel data in Access either by importing the sheet as a table or directly linking to the sheet with no problems in the past but today I cannot seem to get the data to import in the right way.

The column on the Excel sheet is mainly populated by numbers but some of the values have letters in them. When I discovered this I formatted the column as text and tried to directly link to the sheet but the datatype kept insisting it is number. I then decided to import the sheet as a table and although it comes in as Text instead of seeing the value A1030573 in comes in as 7.1e+009 and this goes for the values that are purely numbers.

Is this a known bug, does anyone have a solution to to this ?

Thanks in advance,
Mitch....

 

[systemx]

Hi VegaLA,

When I first starting importing from Excel I had similar problems.

While I cannot recall exactly what I did, I do recall that the problem solution for me definately related to changing the formatting of the excel column.

Just an obvious one...if the excel column is formatted as text, make sure your access field is also formatted as text. With the numbers make sure that the access fields are also formatted to the correct number type.

Cheers,

Rob

 

[Road_Warrior]

Try putting on of the rows that is text at the top. I'm pretty sure Access determines the data type from the first row of data

 

[VegaLA]

Thanks for your replies.
I have the data importing in as text however the values that are numbers in that column, such as 2111122945 come into Access as 2.11112e+009 !
I don't believe that Access can't handle number data in a text field like this.

Any ideas please advise.

Thanks,
Mitch.....

I just pasted the 2111122945 value directly into the Access table and it stores it correctly.