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.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
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
.TXT or whatever format you are after.
Let me know if you need more specifics.