Excel Link to Access

[chriske911]

this is because the general format number is used for the first column and
since a few of the rows contain alphanumeric values you get the #num error
since they cannot be converted into numbers

solution:
in excel set the format of all cells to text or place a ' before every
numeric value in the first column in excel

bon chance

 

[Ice Man]

Dear all

I'm doing in access: File - Get External Data - Link Tables -- to excel file

the excel file have 2 columns:

Mdl Code Mdl Name
A86902099 1000SPB/TE
89610428 10CDQ-80CD3/TE
89610430 10CDQ-80CD3//TE
86901979 10CDQ80C5//T E
86900893 10MFD2HFG/C1E
86900892 10MFD2HFG/CE
86900976 10MFD2HFGC/ZE
86900974 10MFD2HFGP/ZE

CH000007 AFR-CL/OGR
CH000006 AFR-CL/RED
CH000075 AGR-CL/BLK
CH000003 ALR-CL/BEG


When the linked table is created in access it takes by default the 1st
columns as type number
and for this it gives me

#Num! 1000SPB/TE
89610428 10CDQ-80CD3/TE
89610430 10CDQ-80CD3//TE
86901979 10CDQ80C5//T E
86900893 10MFD2HFG/C1E
86900892 10MFD2HFG/CE
86900976 10MFD2HFGC/ZE
86900974 10MFD2HFGP/ZE

#Num! AFR-CL/OGR
#Num! AFR-CL/RED
#Num! AGR-CL/BLK
#Num! ALR-CL/BEG




PLS NOTETHAT i TRIED TO DO FORMAT CELLS IN EXEL AND SET ALL TO TEXT

Could anybody tell me what's wrong plsss..

Thanks

 

[Ice Man]

Hi

I got a solution now (I asked a colleauge) at work

Supposing column B is the one who got too many numeric values

I select all the D column and right click format cell -- > I choose Text
After in Cell D2 I put the following formula =TEXT(B2,"000")
after that I apply the formula (by dragging it to other rows) to all the D
column where necessary (for ex. for 957 rows)

after I do a select all for the column D Copy it then paste special in B
where I choose only Values in the paste special option
After I delete all data in column D (If I want)


and Voila! ...the linked file works fine now in access

a bientot!!!