Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
Can anybody share the macro or vb script to write a table in the access database.
see the following thread:
Possible to write a macro that creates a new table? - Microsoft Access / VBA
see the below link
set MAccApp = CreateObject("MSacess.Application")
MAccApp.Visible = true
set MAccDoc =MAccApp.Dat.Open("Template file")
set PHARMA = MAccDoc.Database("Datasheet Name")
ActiveDocument.GetSheetObject("ChartId").CopyTableToClipboard true
MAccDoc.Database("Datasheet Name").Activate
This should work
Hi devanand,
already table exists in the database. I need to insert the values in the table. does the above code does the same.
hi all,
I already have the table. I need to insert the values into the table..