How I import data without truncating zero in the beginning

M

Mohsin Habib

I am importing data from text file to access database but it is truncating
all the zeros if they come in the starting.... please help me to resolve this
problem as there is a field name telephone number and I need zero in the
starting to distinguish between local and international calls.
 
D

Dale Fye

Are you importing into an existing table, or a new table? I would create a
table with the structure you want the data to come in. Then, I would create
an Import Specification (use the import wizard), and use the TransferText
method with the Import Spec to get the data in the format you want it.

HTH
Dale
 
Top