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.
In Excel 2003, click on Data -> Import external Data -> Import Data.
Click on New Source, ODBC DSN and select choose your ODBC connection
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.
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
Let me know if you need more specifics.