Data type mismatch when opening a table??

[greaseman]

I imported an Excel workbook and created an Access table, called "Unsorted." I then wrote a small VBA module to process the table and create an output table. However, when I run the code, my Openrecordset line gives me a "Data Type mismatch" error. What causes this? I've attached my database (it's small) and if anyone wants to have a look-see and tell me where I messed up, I would truly appreciate it.

Thanking you in advance!!! You guys and girls are great!

 

[WayneRyan]

GreaseMan,

I explicitly declared:

DAO.Database and
DAO.RecordSet

And it ran fine ... except for the error when a "(" is in a column before 3.

I've never seen the type mismatch on that type of open (no criteria).
Very strange!

btw, Is the data in table "unsorted" acceptable? It looks like Field6
spans several records.

Wayne

 

[greaseman]

Wayne,

Thanks for replying.... that's what I "discovered" yesterday also.... that explicitly declaring as a DAO. type worked. And yeah, the data my users gave me is royally squirrely, as are the users. You should see some of the other data I'm "lucky" enough to work with.

In any case, I got my file opens working and it's off to the races.

Have a great day!