defining a database in VBA

[davers5]

I have a VBA procedure that performs a query on a database in excel using ADO. If I define the database beforehand using MS Query the procedure works. However, what I'd like to do is define the database object (using a range) in an earlier procedure. If I have a range of cells in Excel that I want to be a database, how do I make this range a database object?

Thanks for the help,

Dave S.

 

[davers5]

Actually, I don't need to create a whole database, just a table. I think there's something called a Tabledef object but I can't figure out how to define one from an excel range. Any suggestions?

Dave S.

 

[tusharm]

XL doesn't support a database object. It is possible for MS provided Jet/ODBC drivers to interpret any named range as a table. By convention, the first row of the named range contains the field (column) names. To name a range, use Insert | Name > Define... To get the VBA syntax, turn on the macro recorder (Tools | Macro > Record new macro...), name a range by hand, and turn off the recorder.