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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error Message 1

Status
Not open for further replies.
lisa626

lisa626

Programmer
Aug 9, 2006
92
US
I am trying to import a txt file and append into a table and I keep getting the following error, any help would be appreciated. Access 2003


You entered an expression that has an invalid reference to the property |.
 
Sort by date Sort by votes
Are you importing via code or manually.

It could be 2 things.
1. there is a problem with datatypes in the recieving table.
2. There could be a problem with the import specification, this could be a datatype or the "Delimiter/Decimal" symbol.

Herman
Say no to macros
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

soloracer
  • Locked
  • Question
Problem using report recordsource values within report events. Error 2427 1
Replies
17
Views
213
soloracer
soloracer
JoPaBC
  • Locked
  • Question
Rounding error
Replies
4
Views
115
JoPaBC
JoPaBC
Triacona
  • Locked
  • Question
run-time error 2585 - action can't be carried out - while using DoCmd.SendObject acSendReport 1
Replies
17
Views
223
Triacona
Triacona
monkeysee
  • Locked
  • Question
Syntex Error (missing operator) in query expression
Replies
5
Views
120
dhookom
dhookom
JimStrand
  • Locked
  • Question
DoCmd.SendObject Compile Error - Sub Or function Not Defined 1
Replies
5
Views
121
JimStrand
JimStrand

Part and Inventory Search

Sponsor

Back
Top