Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Integrating Excel with Access
I have been given the task of designing a database that would store customer
information. However, It should be done in a way that when an invioce is created in excel it will be automatically recorded in the access database. All help in carrying out this process, is greatly appreciated. |
#2
|
|||
|
|||
to a macro on ms access that will get the data from ms excel
DoCmd.TransferSpreadsheet acImport, 8, "MyTable", MyExel, True, "Print!A4:J18" On ms excel enter this code Function SendData() Dim objAccess As New Access.Application Dim JCServer JCServer = ActiveWorkbook.Path & "\New_TC.mdb" With objAccess .OpenCurrentDatabase JCServer .DoCmd.RunMacro "GetData" .CloseCurrentDatabase End With End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) | |||
How can I open an Access adp file from excel? | Excel Discussion (Misc queries) | |||
Linking Excel to Access. | Excel Discussion (Misc queries) | |||
Managing an Access Database from Excel | Excel Discussion (Misc queries) |