Headed: http://community.9cbs.net/expert/topic/3715/3715027.xml? Temp = .5471002
- Ensure that Excel files and databases are on the same machine. - Execute TRY: - If you accept data imported table already existing insert into table Select * from OpenRowSet ('Microsoft.jet.OleDb.4.0', 'Excel 5.0 HDR = yes; database = c: /test.xls', sheet1
- If you import data and generate a table Select * INTO table from OpenrowSet ('Microsoft.jet.OleDb.4.0', 'Excel 5.0; HDR = YES; Database = C: /Test.xls' ,sheet1
/ * - Description: c: /test.xls For the import / export Excel file name. SHEET1 $ is the work name name of the Excel file, usually add $ to use. - * /
