I am having trouble in the below code its keep getting me error on line
rst.Fields(Cells(1, i).Value) = Cells(x, i).Value
i dont know what the problem is please help me out.
the complete code is here
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
I was wondering if there was some VBA code that could be used to retrieve tables from Access to populate multiple tabs to an existing Excel document? Or create a new document. I suppose either would work.
Please and thank you.
Also posted in Access forum here...
I know there are some similar posts out there, but I’m terrible with understanding macros. Could someone tell me a macro for the following?
Here’s an example data set:
I found a code that I have edited to update access records via Excel (Code below). I have tested it and it works perfectly, however it takes 3 minutes to update 6 records (rows). Is there any way to fix this and make it much faster?
The code searches for the primary key in an excel row, and...
google is not helping with this problem. maybe i dont know enough about vba, but ive tried a few different vba samples and im getting nowhere. i have a sheet in excel that is used daily to track two different things. in the morning supervisors call me to let me know how many people they have...
can ms access be updated when excel is updated?
im working on a project right now where i need a team which keeps adding and modifying data in an excel sheet.What i want here is how can the data added by the team members automatically be updated with the MS access database?
i am a...
I am attempting to build a macro that will take the data in the current Excel spreadsheet, and dump it in the same format in a Access database table.
The Excel spreadsheet has 14 fields and about 35000 rows.
Column A = Index
B = Trans Date
C = Client
D = Plan
E = Member
F = Unit
I need to export a worksheet to an access table. I found this sample code
' exports data from the active worksheet to a table in an Access database
' this procedure must be edited before use
Dim db As Database, rs As Recordset, r As Long
Set db =...
I am starting to learn how to connect between EXCEL and ACCESS using macros. And I've already figured out how to get my information from my EXCEL spreadsheet right into an ACCESS table. This works very nicely. What I'd like to learn how to do is take my information from EXCEL and put it into...