+ Reply to Thread
Results 1 to 7 of 7

NorthWind Traders

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    Houston, TX, USA
    MS-Off Ver
    Excel 2016
    Posts
    58

    NorthWind Traders

    In previous versions of Office, MS had a sample Access database called NorthWind Traders. I am trying to find a copy of this database so that I can export it to Excel.

    OR

    Does anyone have a large Excel file with customer, product and sales information that would be suitable to make PivotTables and PivotCharts?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: NorthWind Traders

    Follow direction found in link.
    https://www.quackit.com/microsoft_ac...oft_access.cfm

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: NorthWind Traders

    Hi,

    Here is another link:
    https://access-templates.com/access+...abase-587.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    12-07-2012
    Location
    Houston, TX, USA
    MS-Off Ver
    Excel 2016
    Posts
    58

    Re: NorthWind Traders

    CK76,

    I have downloaded NorthWind 4 times. I cannot figure out how to export to Excel. When I am at the Export screen, to Excel is grayed out. I also cannot figure out how to go into Excel and import. File | New gives me templates. File | Open gives me Excel files on my computer. Can you give me step-by-step instructions on how to export from Access to Excel, or how to go to Excel and import?

  5. #5
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: NorthWind Traders

    Once template is downloaded and saved as database.

    Login using one of credential provided (I'd use "Andrew Cencini").

    Then double click on the table that you want to export, go to External Data ribbon tool. Click on Excel found in Export section.

    Follow on screen instruction. Note that it won't export linked child fields.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    Re: NorthWind Traders

    Go to a Google and type "export from Access to Excel" into the search box - there are plenty of online tutorials and explanations.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: NorthWind Traders

    To import using Excel (Get & Transform).

    Go to Data ribbon tool and New Query->From Database->From Microsoft Access Database.

    Navigate to the database file location, select the file and hit import. You can choose which table / query to import.
    0.JPG

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Stock Traders?
    By Soes Bandit in forum The Water Cooler
    Replies: 2
    Last Post: 12-08-2016, 04:09 PM
  2. Layout for multiple countries, traders and years
    By azizunreal in forum Excel General
    Replies: 1
    Last Post: 02-03-2015, 11:41 PM
  3. Northwind, the Spreadsheet
    By BaltasarGracian in forum Excel General
    Replies: 3
    Last Post: 03-10-2012, 02:48 PM

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