Excel to get records from MS Access

Hi All,

I want to get the data only of the name that will appear in L1 - this is the part i'm having trouble.

I'm having trouble to get the records from MS Access if I set WHERE = Name

But If only get all the records it works fine.

Anyone can help?

Thanks.

Not downloaded your attachment but have you delimited the value for Name ....?

I think its not about delimited.

here's the code

Please Login or Register  to view this content.

the error im getting is "Too few parameters. Expected 1."

Name is a Text/String field. You needed to delimit the value you are passing in.

Using s phone so no code examples but try adding an apostrophe before and after...

...Name] = ' " & Range("L1").Value &" ' "

Spaces added for clarity, remove them in your code

Still same.

There's nil information in that. "Still same" without showing what you changed to get the 'still same' is pointless.

Read this

Will try again tomorrow. What i meant in still same is its still error sorry about that. That was my mistake for not making it clear

Well that was dumb of me for not trying that.

Thanks all especially mike and cytop