How I import data without truncating zaro in the beginning

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mohsin Habib - 16 Jan 2008 07:34 GMT

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?

Reply to this Message

Jeanette Cunningham - 16 Jan 2008 09:16 GMT

Mohsin,
here is a different way to import a text file, which may get around your
problem.

http://www.rogersaccesslibrary.com/download3.asp?SampleName=ImportLineInput.mdb

Jeanette Cunningham

> when I import data from text file to access data, it truncates all the
> zeroes
[quoted text clipped - 5 lines]
> can
> import data without truncating zaro in the beginning?

Reply to this Message