How I import data without truncating zaro in the beginning

M

Mohsin Habib

when I import data from text file to access data, it truncates all the zeroes
in the starting of every filed, I have a field as "Telephone Number" in which
I need these zeroes in the beginning as I have to distinguish between local
call and international calls, please help me in this regards that how I can
import data without truncating zaro in the beginning?
 

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 zero in the beginning 2
TRUNCATING FIELDS IN LINKED TABLE 4
Trouble importing Excel field correctly 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
import data 1
Download/Import from Tab Delimited - Formatting of Data 5
Import files into access 1
Excel How do I delete images in a specific range 1

Top