| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.sqlserver.server
|
|||
|
|||
how to import an excel table into sql server express?
Hi,
i have a table in an excel file. How can i import it into sql server express? Thanks Ben |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.sqlserver.server
|
|||
|
|||
|
how to import an excel table into sql server express?
Ben
1) Linked Servers 2) OPENDATASOURCE command INSERT INTO tbl SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\MyExcel.xls"; User ID=Admin;Password=;Extended properties=Excel 8.0')...Book1$ "Ben" <b@bn wrote in message ... Hi, i have a table in an excel file. How can i import it into sql server express? Thanks Ben |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I import data in excel form SQL server? | Excel Worksheet Functions | |||
| can not import Excel worksheet in accounting express 2008 | New Users to Excel | |||
| import data into SQL Server from Excel | Excel Discussion (Misc queries) | |||
| excel (vba) and sql server express | Excel Programming | |||
| import and export from SQL SERVER to Excel | Excel Programming | |||
Hybrid Mode
