How to get sheet name from excel file?
Hi, I can connect to an excel file using the following code: p: open [ scheme: 'ODBC target: "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=c:\test.xls" ] conn: first p insert conn "select * from [Sheet1$]" result: copy conn But what if I don't know the sheet name (Sheet1)? I know there are some ways in ADO or .NET or using excel object etc. But is it possible to get it using SQL? (I posted this as a separate question because people may don't look the my other post as it looks already answered)
posted by: Endo 29-Jun-2010/7:21:24-7:00
Well, ok, I did it as mentioned in SDK docs. insert p ['tables] r: copy p ;gives useful informations third first r ;gives the name of the first sheet >> "Sheet1$"
posted by: Endo 29-Jun-2010/8:01:35-7:00
|