thelner

It worked!!!! Thanks a lot!!!:)

Oww, thanks sir. What do you suggest i use then. To copy a table into another table. :)

MS Access....

I think my SQL statement is the problem. Can you please give me an example statement that creates a table then copies the content of another table. Dont know if i need to use INHERITS os CREATE TABLE AS. Proper syntax so that i could use it with vb.net please...........:) EX. "CREATE TABLE qwerty INHERITS yuiop" (which i know is wrong since it gives an error)

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

Hi, im new to programming so pleaser bear with me :) Im trying to make a program that creates a table for every entry on a table(store) and inherits (store sample). But it has error. Can somebody please point out to me what im doing wrong....... Dim cmdstr As String = "" Dim rdstr As String = "" rdstr = "SELECT store FROM stores" con1.Open() con2.Open() Dim cmdread As New OleDbCommand(rdstr, con2) Dim objreader As OleDbDataReader = cmdread.ExecuteReader() Dim cmdmke As New OleDbCommand(cmdstr, con1) Do While objreader.Read() objreader.Read() cmdstr = "CREATE TABLE [" + objreader("store") + "] INHERITS [store sample]" Label1.Text = objreader("store") cmdmke.ExecuteNonQuery() <<<<<<<<<<< ERROR!!! Loop con1.Close() con2.Close()