How do I INSERT data into an excell spread sheet ODBC?

  • Thread starter Thread starter jonsegue
  • Start date Start date
J

jonsegue

I am trying to use the ODBC excell driver and trying to
insert data into my spread sheet as if it was a data
base. How do I do this and are there any publications of
the functionality of the ODBC driver used to access EXCEL
FILES?
 
If you go to the Data menu, Get External Data, New Database Query, th
wizard will start to walk you through the rest of it. You will see
list of databases to choose from and once you select your database yo
will be presented witht he list of tables. Click on a table and yo
will see the list of fields available in that table
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel ODBC driver created table/data not persistent 2
ODBC Issue with Pivot Table 1
exel spread sheet 3
odbc error on Excel query into database 2
Managing ODBC connections 1
Excel connection to ODBC database 10
How do I insert a file in to an excel document 3
Excel ODBC driver created table/inserted data lost on application 1

Back
Top