Question: Hello I need help with using external data in Excel. Please see attached. Please help me out Hello, I want to import Access forms data

Hello I need help with using external data in Excel. Please see attached. Please help me out

Hello, I want to import Access forms data to Excel file

So, I followed these steps:

Data - Get data From Database From MS Access Database

Connection String Source is through my computer

Like

C:\Users\Rory\Desktop\files\Final Product\form1.accdb

And I need to send these both file to my friend (Access & Excel)

So when she try to open the excel file the connection gives her an error.

So How can I create a relative path that will work for her computer as well?

Like for Linux we do this - .\myfilename.accdb

What should I do for the excel? Please let me know

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!