Need Help with getting DAO to work in VBA Project in Excel 2013-64 Bit

kleaverjr · 05 Jun 2017

0 down vote favorite

I have searched using google to find a specific answer with no luck. I keep getting error code 429 when trying to use DAO language "OpenDatabase" so I can use SQL Language to search various worksheets in one Excel 2013 Workbook. I am running Windows 7-64 and Office 2013 64-bit. From what I have read, it would appear DAO is not supported anymore by Microsoft, and even ADO doesn't look like it is looked favorably by the folks at Microsoft anymore. I really don't care if I can't use DAO anymore as long as if there is a method where I can use similar functionality to find specific records based on specific criteria, amend certain records, create other records, and move amongst records (i.e. .movefirst, .movelast, etc.). If there is a different VBA language that is usable for 64 bit versions of my software, I will learn it.
I rather not use the workbook, worksheet functions and using IF-THEN statements going through the entire table trying to find certain "records" that match the criteria I am looking for. It works, but its tedious and I much rather use SQL type language.
I realize using MS Access would be more appropriate, but I prefer using the Spreadsheet format. What I am trying to do is write a VBA program that converts certain cell values into a certain format to be converted to a csv file to upload to a website for my web-store. The file is my inventory sheet, with tons of calculations/formulas in it. I rather not use MS Access if I don't have to.
Thank you for any help that can be provided!
Thanks.
Ken L.

HiTechCoach · 07 Jun 2017

FYI: Access can link to the Ecel workbooks as tab;es. Youc an easily query and export to do what you need with Access using the excvel data.\

Note: I use Access are a Report Writer for Excel data.

HiTechCoach · 07 Jun 2017

Ken L.,

FYI: Access can link to the Excel workbooks as tables. You can query the excel data easily. With Access, tou probaly can do it what yu need with only aquery and NO VBA code.

Note: I use Access are a Report Writer for Excel data.

kleaverjr said:

If there is a different VBA language that is usable for 64 bit versions of my software,

No.

AFAIK, Micosoft is the sole owner/provider/creator of Visual Basic for Applicatoins (VBA). There is only one core VBA engine for 32-it (mature) and one for 64-bit (new). Each Office Applicaiton has the same core VBA with additional functionalityadded based on the application's object model needs.