Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Importing data from an excel file into Access table where user specifies file name and cell range
1 view
Skip to first unread message
ssa
May 17, 2011, 7:14:38 PM5/17/11
to
Basically what I am trying to achieve is a simple process for a novice
Access user to import certain data from a spreadsheet each month. The
cell range and file name will change each month so it is imperative
that the user be able to select both of these.
Access user to import certain data from a spreadsheet each month. The
cell range and file name will change each month so it is imperative
that the user be able to select both of these.
Any suggestions on how best to do this. I was thinking of maybe doing
this using a command button on a form. But any suggestion will be
helpful. Also coding help is useful, since I am still pretty new to
coding.
Thank you in advance for any help!
Ken Snell
May 17, 2011, 8:19:12 PM5/17/11
to
See reply in externaldata newsgroup.
--
Ken Snell
http://www.accessmvp.com/KDSnell/
"ssa" <sal...@gcamail.com> wrote in message
news:6238abae-c852-422d...@k16g2000yqm.googlegroups.com...
0 new messages