Using ODBC to manipulate Excel

For a reason, yesterday my old daddy asked me to help him put some Excel data into the FoxPro database, according to the requirements of the table structure, but also to do some processing. (I faint, there are people in these days with FoxPro)

As a then, I installed that n years have no use of Visual Studio 6.0, read a half-day MSDN, simple little play FoxPro, feel too retarded, not too accustomed.

Thought since FoxPro is also a small database, should support ODBC connection bar, and then I can use Java or Python, such as direct operation of the language.

I didn't think. Open ODBC data source settings A look, incredibly even Excel support ODBC, really did not think

Export data from Excel, the usual idea is that you can save it as a CSV or XML, and then casually take a language analysis, did not expect Microsoft is more considerate, directly build a DSN, and then write the SQL statement, hehe

By the way, the name of the table in Excel is [sheet1$], which must be written as SELECT * FROM [sheet1$] to choose Sheet1, specifically why ask m$.