OpenRowset on a dBase IV file
Has anyone had any experience using the openrowset function to access a dbase IV file? I can access the file using ADO from within VB but not getting anywhere using openrowset. If anyone knows the syntax or has an example it would be greatly appreciated.
Thanks in advance...
Jim
Correction to my previous post - NOTE
I can't edit my posts and I made a stupid mistake when I converted my SQL to generic form for the above reply...
So besides replacing all of the "OfDBF" instances with your own real names, you'll also have to add an essential comma I accidentally deleted from my example. It should go right after "FolderOfDBF'".