Results 1 to 5 of 5
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Locating Clarksville Ice Cream.xlsx file

    It says in the tutorial lesson 5 shown here:



    http://www.functionx.com/access/Lesson05.htm

    from the resources that accompany these lessons, open the Clarksville Ice Cream.xlsx file.

    I do not know where to find this file; I am unaware of its location.

    Where may I get or download this file?

    Any help appreciated. Thanks in advance.

    Respectfully,


    Lou_Reed

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    On the Home page for the site : http://www.functionx.com/access/index.htm

    ...down at the bottom of the page is a hyperlink: http://www.functionx.com/access/resources.htm

    Maybe that will be useful!



  3. #3
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I will try it. Thanks.


    Respectfully,


    Lou_Reed

  4. #4
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    That worked.

    Now when I continue with the tutorial (whose link is above and repeated here (http://www.functionx.com/access/Lesson05.htm ). I get to a where it says:

    In the second page of the wizard, click First Row Contains Column Headings check box

    I can click the checkbox, but my first row contains the name "Clarksville Ice Cream Company"

    and the next two rows are blank and the forth row contains the column heading. I am not sure where I
    went wrong, but the Clarkesville Ice cream Company file, the Excel file is untouched.

    So my column headings are in the forth row. How can I inform MS Access 2010 that is where my column headings are and not the
    first row.

    Any help appreciated. Thanks in advance.

    Respectfully,


    Lou_Reed

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Does it answer that question for you later in the lesson?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Export .xlsx file to internet address
    By Back2Basics in forum Import/Export Data
    Replies: 4
    Last Post: 04-09-2015, 03:58 AM
  2. vba to Export Multiple Sheets to xlsx File
    By jhrBanker in forum Import/Export Data
    Replies: 3
    Last Post: 09-23-2013, 01:00 PM
  3. Replies: 6
    Last Post: 07-23-2013, 11:57 AM
  4. Replies: 6
    Last Post: 02-07-2013, 03:15 PM
  5. Open Excel .xlsx file from Access
    By Bigmix in forum Programming
    Replies: 6
    Last Post: 02-28-2012, 09:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums