By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,293 Members | 1,390 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,293 IT Pros & Developers. It's quick & easy.

Table import dialog box

P: n/a
i'm new to VBA and i need to Build a Dailog form that will enble me to
import .csv or .xls
files to access. anybody directs me where can i find already built
form on line OR what functions or method to use
help please
thanks
Dec 13 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Use the code in this link for the File Open dialog:
http://www.mvps.org/access/api/api0001.htm

Then use TransferText to import a CSV, or TransferSpreadsheet to import an
XLS.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"xtopia" <ya********@gmail.comwrote in message
news:75**********************************@b1g2000p ra.googlegroups.com...
i'm new to VBA and i need to Build a Dailog form that will enble me to
import .csv or .xls
files to access. anybody directs me where can i find already built
form on line OR what functions or method to use
help please
thanks
Dec 13 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.