Insert a Table into an Access DataBase

[plopez]

Hi...I need to know the way to insert a Table into an existent Access DataBase using VB6 Code.

I appreciatte ur help.

 

[Golom]

Do you have an existing table somewhere (another database for example) and you just want to copy it to an Access DB?

OR

Do you want to create a NEW table in an Access database?

 

[waytech2003]

See FAQ

 

[ChewDoggie]

sql = "CREATE TABLE YourTableName(FieldName1 Char(40), FieldName2 Char(25), FieldName3 INT, FieldName4 Char(8))"
cn.Execute sql
DoEvents

HTH


The True measure of an individual is how he treats a person who can do him absolutely no good.

 

[plopez]

I am creating a table with VB6 Code and I need to add this table to an existing Access DB.

 

[Golom]

waytech2003 and ChewDoggie have given you two ways to do it. Take your pick.