Import from Excel to an access database using Jet in vb.net

  • Thread starter Thread starter Andy HP
  • Start date Start date
A

Andy HP

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 when 'myDatabase' is password
protected ?

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
 
how u declare 'MyDatabase' is a proper way?
It will have the error if u just simply write 'MyDatabase' inside the code because it have not state the path of location of the database. can show me the full coding? thanks!
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 when 'myDatabase' is password
protected ?

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

Submitted via EggHeadCafe
Stock Quotes via jQuery-enabled WCF Service, JSON, and jQuery Templates
http://www.eggheadcafe.com/tutorial...ed-wcf-service-json-and-jquery-templates.aspx
Click to expand...
 
Back
Top