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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top