excel to access

  1. I

    Exporting Data from Excel (Dynamic Range) to Access Table

    Hi all, 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 Sub Export_Data() Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim dbPath...
  2. K

    VBA to retrieve Access tables to populate worksheets in Excel...

    Hi all, 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...
  3. T

    Converting Horizontal Data to Vertical with Intentional Redundancies

    Hi everyone, 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: <tbody> A B C D E F G H 1 Date Status 2 ID First Last Service Group...
  4. E

    Extremely Slow VBA Code - Update Access via Excel

    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...
  5. S

    need help to import excel ranges to access tables with excel macro vba

    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...
  6. A

    MS Excel to MS Access Updation

    hi there, 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...
  7. N

    Macro to Export Excel Spreadsheet to Access Table

    Hi, 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 G =...
  8. J

    Export Excel 2010 Worksheet to Access 2010 Table VBA

    Hello, 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 =...
  9. girlscout

    Push data from EXCEL into ACCESS form

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top