Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing from a TXT file. Leading zeroes removed!

Status
Not open for further replies.
ekimr

ekimr

Technical User
Jun 28, 2002
124
GB
Hi,

Can anybody tell me when I import data from a TXT file, using 'Get external data', how I keep the leading zeroes that are in the file (or maybe show the leading zeroes in the table!)

I have used the defaults on importing.
 
Sort by date Sort by votes
Within the import wizard, ensure the data type for that field is text. If Access sees what appear to be numbers it will import them as such and therefore lose the leading zeroes.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JayRo71
  • Locked
  • Question
Importing only unique records from excel tables 1
Replies
10
Views
551
SkipVought
S
JayRo71
  • Locked
  • Question
Saved Imoorts problem with file name
Replies
10
Views
496
Andrzejek
Andrzejek
raywood1
  • Locked
  • Question
Reducing a Massive Linked Table
Replies
4
Views
457
dhookom
dhookom
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
400
SkipVought
S
ameedoo3000
  • Locked
  • Question
Send a message to an email
Replies
2
Views
2K
ameedoo3000
ameedoo3000

Part and Inventory Search

Sponsor

Back
Top