Import data into Calc using ODBC

I want to import the data from a table through ODBC. I registered my ODBC data source through OO Base. I can see the table and data that I want to import in OO Calc data sources.

I just do not know how to get the data down into the spreadsheet from the preview window on the top. Either it is not intuitive or I am slow today!
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

OK, just to make sure I understand the questions.  You have set up your database in OOo Base and clicked to register the database.  You can Press F4 in Calc and you can navigate on the left to see the tables and/or queries you wish to use.

If all this is true, now all you need to do is click and drag.  For instance if you want just the 1st column and 1st row of a table in Cell A1, just click on the piece of data in the Data Source window and drag it to Cell A1.  If you want the whole table, just click on the box in the upper left of the table window and drag it to the spreadsheet.

Also if you want the whole table you can right click on the table in the explorer type window and choose copy.  Then go down to your spreadsheet and paste.

You can also check out this short little how to to see more options -

Let me know if this helps.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cowisAuthor Commented:
That did it--thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.