I'm using the help screens and all they show is create tabledef.
Is there anyway they could make the help screens more obtuse, or create less
useful examples, or "see alsos" that point nowhere?
The reason I'm doing this programmatically is that it creates a new database
and a new table based on named ranges in an excel file. I won't know in
advance exactly which ranges exist, because the excel table is created from a
pick list in a third application.
I'm sure it is in there somewhere, and I'm a blithering idiot for not being
able to find it, but so far, no luck.
So the drilll is to have Excel Open and creat a database, create a table (or
tables) in that database, and then populate the table(s) fields with data
from the named ranges.
I know that you can create a tabledef so you can manipulate the properties
you want in your table, and then use the tabledef to create the table.
From the help screens:
"You manipulate a table definition using a TableDef object and its methods
and properties. For example, you can: " ......
Which is fine to know you can do that, but nowhere that I've found does it
say "HOW". It says you can creat a table from the tabledef by using the
OpenRecordSet method, but when you look that up it mrerely says
"Creates a new Recordset object and appends it to the Recordsets collection."
I understand that recordests are usually query driven subsets of a table or
tables. There is also a table type recordset object, and when you look that
up it tells you you can create it from a table!
That is not very helpful of the help screens because I'm trying to create
the table I need the recordset for. Neither are my textbooks helpful on this
subject.