oAccess.DoCmd.CopyObject , TableA,acTable ,TableB ( I wanted just to copy a column here into existing TableA ,instead of the whole table)
I could copy the existing table as a whole into a new table , but I couldnt just copy a column to the existing table.
Can anyone help with this.
Thanks in advance.
Are you trying to copy the data from column a to column b? If you are you should SQL to copy the data eg:
INSERT INTO TableA (ColumnA) SELECT ColumnB FROM TableB.
If the column doesn't exist in tableA then you need to create it first. It would be easier to run it from Access directly, but if you have to do it in VB you could use ADO.Command to run the INSERT statement on the Access database - you just need to connect to the Access database in the ADO connection string