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

Linked Excell data errors

Status
Not open for further replies.
Blorf

Blorf

Programmer
Dec 30, 2003
1,608
US
Hi. When I link to Excel, I get some fields with the #Num! error.

I would like to query the sheet, and only return rows with that error in it, but all conditioning fales, so I am stuck. I tried iserror, but that didn't work.

Thanks for any help,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Brand new lock violations errors all over my database
Replies
11
Views
4K
dhookom
dhookom
combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
1K
combo
combo
MattGreer
  • Locked
  • Question
Select the first maximum value from a set of data 1
Replies
10
Views
944
MattGreer
MattGreer
BTilson
  • Locked
  • Question
Dealing With # In Imported Data 2
Replies
5
Views
297
sxschech
sxschech
JoPaBC
  • Locked
  • Question
Update data directly in select query recordset 1
Replies
10
Views
412
JoPaBC
JoPaBC

Part and Inventory Search

Sponsor

Back
Top