In the amazon download Execl need to turn the data into our system database to extract data, extract the data display error,


Use notepad to open after the show is not garbled

Execl can be normal open,

But in the executing code Conn. The Open (); Open tip "external table is not the desired format,"


After execl save as can be normal to extract data,

Now I don't know with what method need not open the execl save as can be extracted directly to the data, the boss said every time open the save as too much trouble,

Could you tell me how to solve the warrior this change,,
Online, such as

CodePudding user response:

This file is not the real excel format, is a text format, use of excel save after opening a can

CodePudding user response:

Data sources into a CSV or modify the program

CodePudding user response:

Solve the Excel import error: external table is not the expected format