you mean, we need to directly export the table into the database(Backend) of the Sharepoint. So, is it not possible to export table into a sharepoint site without database information/configuration details?
'Retrieving Data from Access Database
Set objConnection= CreateObject("ADODB.Connection")
objConnection.Provider="Microsoft.Jet.OLEDB.4.0"
objConnection.Open "D:\Technical Materials\Access\new.mdb"
set rs = CreateObject("ADODB.recordset")
sqlquery = "SELECT * FROM NewTable"
rs.Open sqlquery...
I haven't use access in any of my previous vbs code. Just started learning, I know how to create a object for the access application and to open the database.
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase("D:\Technical Materials\Access\new.mdb")
Next Steps...
I have a table created in MS Access Database. I want to export that table to sharepoint portal.
This can be done manually by following the below steps.
1. Right click the table in MS Access and select export.
2. Choose 'Save as Type' as Windows Sharepoint Services'
3. Then you need to provide...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.