D
David
Hello all,
I have a front end database A20022, mde front end file, for multiple users
on a shared network server, trying to make this as simple as possible. User
is used to working with Excel, I have 5 or 6 columns of data I want them to
import to a table, and the UI can take it from there.
I have tried a solution of building a continuous form, user selects all
cells in the excel spreadsheet, cntl+C, click on record selector, cntl+V.
But the columns must be in that particular order. Users have a tendancy to
rearrange columns.
I have tried using the long code for the user to select the excel file to
import, but I can't figure it out, and the columns being rearranged is still
a problem.
I know how to create a button to launch a specific excel file (template
file), user saves it, import the data and then delete the excel file and
replace with a new blank excel file, but with mutiple users, this could get
tricky.
Is it possible that I can embed a template excel file in Access that when
opened is the user's instance of that file and not on the shared server? If
so how? If not, any suggestions?
And my last question, is it possible to write vba code on the excel file
that will throw the data in an Access Table?
Many thanks, this newsgroup is awesome.
I have a front end database A20022, mde front end file, for multiple users
on a shared network server, trying to make this as simple as possible. User
is used to working with Excel, I have 5 or 6 columns of data I want them to
import to a table, and the UI can take it from there.
I have tried a solution of building a continuous form, user selects all
cells in the excel spreadsheet, cntl+C, click on record selector, cntl+V.
But the columns must be in that particular order. Users have a tendancy to
rearrange columns.
I have tried using the long code for the user to select the excel file to
import, but I can't figure it out, and the columns being rearranged is still
a problem.
I know how to create a button to launch a specific excel file (template
file), user saves it, import the data and then delete the excel file and
replace with a new blank excel file, but with mutiple users, this could get
tricky.
Is it possible that I can embed a template excel file in Access that when
opened is the user's instance of that file and not on the shared server? If
so how? If not, any suggestions?
And my last question, is it possible to write vba code on the excel file
that will throw the data in an Access Table?
Many thanks, this newsgroup is awesome.