Toad World® Forums

Access and ODBC


#1

Is there a way to run a query using an ODBC connection that creates a table in an Access database? I only see the option under export wizard to create a new database and in the beta of 2.7 it looks like you can only create a new table when using an Access connection


#2

We will be adding the ability to create new tables in an existing Access database as well as append in one of the upcoming releases.

In the meantime you can use the QueryBuilder and change the statement type to Create View and this will create a query/view. Not exactly what you are asking for but may help for now. This will display under the Query tab in the Object Palette.
Debbie


#3

Just to clarify, in the future release you will be able to append to an access database using an odbc query? Or would you only be able to create a new table within an access connection?