Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import from Excel into database using jet in VB.net
I can import data from Excel to a non protected access database using the
code below. How can I amend the code to import the data into the password protected database myDatabase ? Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=myExcelFile;Extended Properties='Excel 8.0;HDR=YES;'" Comm.CommandType = CommandType.Text Comm.CommandText = "SELECT * INTO tblNEW IN 'myDatabase' FROM [Sheet1$]' Comm.Connection = Conn Conn.Open() Comm.ExecuteNonQuery() Conn.Close |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Database query to import from Access to Excel | Excel Discussion (Misc queries) | |||
Using Excel for MySQL database import | Excel Discussion (Misc queries) | |||
import paradox database into excel | Excel Discussion (Misc queries) | |||
Import from Database using field from excel. | Excel Discussion (Misc queries) |