Data loss while importing. Help!

[James Pang]

Hi Saviour,

I'm currently encountering problem with my import from
Excel to Access table. The excel data has the similar
field name as the table. However those data with "Alpha-
numberic" cannot be capture.

FYI: this particular field (in Database) format is TEXT.
while the particular field (in Excel) format is General.

(At the similar column of data) the data consisting only
number are captured. Alpha-numeric arent't.

Pls help!

Cheers & Thanks.

Rdgs,
James Pang

 

[James Pang]

Sorry, Problem Solved!

I made a mistake in the TEMP database (where it's format
is NUMBER not TEXT).

Excel (TEXT) --> TempDB (NUMBER) --> ActualDB (TEXT)

so data is loss in the 2nd throwing of data !

James Pang