+ Reply to Thread
Results 1 to 2 of 2

Populating specific cells with SQL Server data

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    Iowa
    MS-Off Ver
    Excel 2007
    Posts
    8

    Populating specific cells with SQL Server data

    A user has an excel document and there are 5 specific cells they need to populate. The data is in one of our SQL databases. Is it possible to create a new copy of that excel doc with those fields populated for each record? There are around 2000 records they don't want to manually populate each one.

    I have never tried this before so not even sure if this possible or not.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Populating specific cells with SQL Server data

    You could link your SQL database to Excel and retrieve the data to a spreadsheet and then populate your specific cells.

    On your ribbon, click on the data tab and external data and Other External Data and SQL Server. Follow the wizard to collect your data.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1