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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I import data without truncating zaro in the beginning 1
Memo Text Truncating 1
truncate zero in the starting when importing from text file 4
Truncating data in drop down list 6
Access: how to get final zeros to show in decimals (ex. 0.530)? 7
Forcing Excel to Import .CSV data 2
For-Next by a row Counting consecutive Zero in the column 4
TRUNCATING FIELDS IN LINKED TABLE 4

Top