UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> How To Link An Excel In Access, Access 2016    
 
   
Lin100
post Oct 18 2019, 11:23 AM
Post#1



Posts: 653
Joined: 20-August 06



How do I link an Excel file in Access where the first two rows in the Excel file is a heading that contains no data.
The third rows will contain data.

In an attachment, the picture Linked Table Manager has A3:R500 in Data Source Information.
This allow a user to open a link Excel file where the first two rows is not showed in the table,
so that the table display data on the first row with a field name like in a standard Access table.

I tried a new link but there is no where I could put in A3:R500 in Data Source Information
Attached File(s)
Attached File  Linked_Table_Manager.jpg ( 116.11K )Number of downloads: 8
 
Go to the top of the page
 
theDBguy
post Oct 18 2019, 11:34 AM
Post#2


Access Wiki and Forums Moderator
Posts: 76,491
Joined: 19-June 07
From: SunnySandyEggo


Hi Lin. Just a guess but in the Excel file, try creating a named range and then when you link it to Access, select the range name instead of the sheet. Hope it helps...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Lin100
post Oct 18 2019, 02:03 PM
Post#3



Posts: 653
Joined: 20-August 06



Thank you for your help.
Go to the top of the page
 
theDBguy
post Oct 18 2019, 02:10 PM
Post#4


Access Wiki and Forums Moderator
Posts: 76,491
Joined: 19-June 07
From: SunnySandyEggo


Hi. You're welcome. Did it work? Just curious...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    13th November 2019 - 05:16 AM