How I import data without truncating zero in the beginning

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mohsin Habib - 16 Jan 2008 08:24 GMT

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.

Reply to this Message

Vincent - 16 Jan 2008 11:06 GMT

Remplace them by "+" (normaly it's the same)

>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.

Reply to this Message

Dale Fye - 16 Jan 2008 16:16 GMT

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

Signature

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

> 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.

Reply to this Message