Data loss while importing. Help!

  • Thread starter Thread starter James Pang
  • Start date Start date
J

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
 
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
 
Back
Top