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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started