database connection

  1. B

    Connect SQL Database to Forn Activation

    Hi, I'm new Userform and when the form activate a dropdown list must be populate. I can't get my project to connect to the SQL database. With all my searches I found these code but I have no idea where to place these code. I have tried to place them in Userform activate but I get an error...
  2. F

    Database connection in VBA

    Newbie question: In a project with a number of subroutines and functions that query and update a database, is there an advantage (or disadvantage) to having just one global database connection that is opened upon initialization of the project and stays open until the project is closed?
  3. E

    [vba] Changing connection commandtext in many connections

    Hi everyone I have a spreadsheet which has many connections to various databases, every month one line of the command text in a large number of these connections needs to be changed, i.e. from 'between 1222 and 5222' to 'between 5223 and 7234'. Currently this is done manually which is quite...
  4. V

    Connect Excel 2016 to POSTGRE SQL database

    Hi everyone, I'm trying to connect my Excel workbook to a postgresql database. I've found this link on the internet but it didn't really helped me. https://support.office.com/en-us/article/Connect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4 In fact, they are...
  5. E

    Using replace function to change database connection commandtext in vba macro

    Hi everyone I have a spreadsheet with a lot of tabs that looks up to a database and needs refreshing every month. However the command text has to be changed in each tab every month. I have worked out how to change the entire command text to a value in the spreadsheet but it changes the whole...
  6. L

    Populating A Master File - Managing Work Log Hours

    I am managing the volunteer hours for a volunteer fire department. In a nutshell, the member logs in to the website, fills out a form, and then at the end of the month, the admin exports the data. The website template provider doesn't allow us to change the export features, but we can change the...
  7. D

    Copying data to a new workbook

    Hello, I have a workbook that's set up to query a database and return values. I need to send this workbook to others who do not have access to this database. If you don't have access to the database, errors are returned rather than the values. What I need to do is somehow copy and paste the...
  8. E

    Updating Master Excel Sheet from multiple spreadsheet Dynamically

    Hello, mrExcel! This is my first post, so please be kind. I have some moderate VBA experience. Here is the situation I am seeking advice on. I am part of a compliance team and I handle the 'automation' part. We are currently in the midst of a User Access Review that is being handled via excel...
  9. P

    Target audience not Power Pivot enabled

    Hi, Quite new to PP. I can already produce quite useful dashboards with slicers. Problem is that the reports need to go to a target audience (Exco) and they are not using PP (whole corporation is on XL2010). What is needed to be able to share the dashboards with connected databases? I tried...
  10. K

    Using VBA to pull data from mySQL to excel with Macro button

    Hey everyone, So I have a materials database made up in mySQL, which holds linked tables for materials, manufacturers and vendors. I also have a Bill of Materials (BOM) in excel, in which there are empty columns for manufacturers, vendors, etc. The goal is to have a Macro button that, once...
  11. A

    Find data using command button in access 2010's form from a table in different .mdb file

    Hi I have two different access files. One is 2010 format where I have the form and another one is 2007 format where I have the table and this file is in a different path. Is it possible to search and pull the data from table to the form using a command button. If possible please help me with...
  12. R

    VBA- Excel to Oracle DB Connection Issue

    Hi All, The below code to connect excel to oracle database is showing run time error. Error at : src_conn.Open varConn Did anyone phased this issue before? Please let me know if anyone can resolve this issue.... :-) Private src_conn As ADODB.Connection Private Rec_set As ADODB.Recordset...
  13. J

    VBA fails to update a linked table - works on step through / with timer / with manual refreshall

    Hi I have a table in Access linked to 3 separate Excel sheets. They contain user forms which update the records in the table with information input into the form. Within the userform code, I'd like to do 2 things: 1. Update the records in the datatable with the user form info 2. Refresh the...
  14. M

    MS SQL 2008 connection with VBA

    Hi, I am looking to connect to a Microsoft SQL Server 2008 db with VBA and pull data with SQL. I would be using Windows Authentication. I've tried googling but couldn't find any MS SQL SERVER 2008 specific guides on how to do so. I've found this but I am not sure I understand how it works...
  15. C

    Determine if Access Table exists using Excel VBA - XL 2010 - Windows 7

    Is there a way, in Excel, to determine if a table in Access exists? I have code which currently sets up a connection to Access and returns data to Excel from a Access table. However, if the table does not exist then I want the macro to do something else. Thank you.
  16. I

    Moving and massaging data

    Hello everyone, I have a table connected to a survey hosted on SharePoint. As new responses are added to the survey they are brought into excel. In the same workbook on another worksheet I convert the answers from the survey into values, tally the values and determine an overall score. Being...
  17. E

    Basic Code to Open and Write a Record to Access

    I'm using Excel and Access 2010 and have been searching for some simple code to open and write data from an excel spreadsheet appending to a table in Access. I have already successfully defined a connection via Excel's external data query to load the table into a sheet. However, at the end of...
  18. J

    Vlookup to reference another Workbook

    Hi all, I am hoping y'all can help me with something. I have several large (big enough to not make it practical to combine them) workbooks in 1 folder on a shared server. I have created a seperate workbook to pull data from these workbooks based on a "customer number" criteria. What i would...
  19. K

    Using VBA Excel to Export Data to 'JobBOSS' (Sql Server Database)

    Hello, I am very new to VBA and computer Database programming in general, so any information or guidance would be appreciated. I have got an Excel Stocklist with flieds: Article Name, Description, QTY and Tray I am hoping to upload just the QTY column to the 'JobBOSS' Database and update the...
  20. G

    Best way to use a remote Access database + Excel + VBA?

    Hello all. As always, thanks for this repository of knowledge and experience. I manage a growing retail firm that has recently expanded from a single-location to two locations and a separate warehouse. Initally I was tasked with developing a Point of Sale system that would track our inventory...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top