macros

[raadwiptec]

hi all,

Can anybody share the macro or vb script to write a table in the access database.

[Anonymous]

see the following thread:

Possible to write a macro that creates a new table? - Microsoft Access / VBA

[Siva_Sankar]

Problem with WriteBack to MS-Access

[Kushal_Chawda]

see the below link

Update and external Database with a Macro. | Qlik Community

[#5]

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

[raadwiptec]

Hi devanand,

already table exists in the database. I need to insert the values in the table. does the above code does the same.

[raadwiptec]

hi all,

I already have the table. I need to insert the values into the table..