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!

Import Error

Status
Not open for further replies.
Roosters

Roosters

Technical User
May 14, 2000
61
AU
When importing a column from excel formatted to text that contains predominantly number entries all cells with text entries are not imported (blank), only the cells with the number entry are imported. This has had me stumped for a while, I would appreciate any idea's.

Thanks Phil
 
Sort by date Sort by votes
Hi Phil,

I believe this is a bug/limitation. This was mentioned 1/2 week(s) ago. The only way round this (I think) is to make sure that your first value is a text value. Eg. Just add an 'A' to your first cell, so 123 becomes A123. This is a messy way. especially if you want automation. Maybe someone else has a better solution.

Nick
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
247
Axworthy
Axworthy
DB_Bowes
  • Locked
  • Question
Selection from Listbox to GoTo Record in Bound form Gives Error 2105
Replies
1
Views
189
DB_Bowes
DB_Bowes
bosk0
  • Locked
  • Question
Getting a syntax error in INSERT INTO statement 1
Replies
5
Views
180
Andrzejek
Andrzejek
DeRochier
  • Locked
  • Question
Subform triggers error: "This expression is typed incorrectly..."
Replies
3
Views
256
DeRochier
DeRochier
TrekBiker
  • Locked
  • Question
Allen Browne's duplicate record method giving error 1
Replies
2
Views
115
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top