Import Question

[nwalk81]

Hello All,

The current issue I'm having in my database is the same as thread707-1203611.

I'm just confused as to the correct coding to fix this issue, I have not to date used the Recordset property, and have only used DLOOKUP in Excel.

Can someone please help?

Thanks in advance.

 

[PHV]

So, what is your actual code and where are you stuck ?
have only used DLOOKUP in Excel
???
DLookUp is a method of the Access.Application object (and not a VBA function).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nwalk81]

I have no code for this situation as I am unsure of the correct coding to check my import file against my current data (to avoid duplicate entries). DLookup being a Access application is not a problem for me, can you just explain which is better and how I would achieve my desired results.

Thanks

 

[PHV]

Please, read carefully this: FAQ181-2886