Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then exporting the database into a flat file?
The program I am accessing data only allows an ODBC connection in. Not sure what database it is.
Asked
Active
Viewed 3,448 times
2
-
It's possible. What version of excel? That will change the instructions. – JNK Aug 27 '10 at 15:09
-
It is Excel 2003 – Daniel Aug 27 '10 at 15:41
2 Answers
3
In Excel 2003, click on Data -> Import external Data -> Import Data.
Click on New Source, ODBC DSN and select choose your ODBC connection
Sathyajith Bhat
- 61,504
- 38
- 179
- 264
2
I'll assume Excel 2007 and if it's different we can change the answer here. I'm also assuming MS SQL Server.
1 - Set up data connection. Data Tab -> From Other Sources -> From SQL Server
2 - Enter info into Wizard for SQL conneciton.
Your best bet to export to a flat file is to save your SQL table link to a new worksheet, then save that worksheet as a CSV or .TXT or whatever format you are after.
Let me know if you need more specifics.
Sathyajith Bhat
- 61,504
- 38
- 179
- 264
JNK
- 8,218
- 28
- 31
-
-
-
Not sure what the backend database is, just that i can access it via ODBC. – Daniel Aug 27 '10 at 15:49
-