469,938 Members | 2,492 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,938 developers. It's quick & easy.

Loosing Format when importing

Hi there,

I'm trying to import a text file direct into a MS Access database with
the folowing command line :

INSERT INTO < table name > SELECT * FROM [Text;Database=" &
myPathVariable & ";HDR=YES;].[" & myFileVariable & "]"

Even though my MS Access table is a string field, if I send a value
like 000000123, it's saving the information as 123, losing the zeros.

Any thoughts ?

Thanks in advance

Kucho

Jan 26 '06 #1
0 782

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Fabian Kr?ger | last post: by
4 posts views Thread by Matt | last post: by
3 posts views Thread by veaux | last post: by
5 posts views Thread by E.Bartosiewicz | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.