Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

Need to get somewhere quick in Access 2007

I'm a VB programmer working on an Access 2007 Database.  Very unfamiliar with Access 2007.

I need to perform these functions and I'm rushed for time:
1.  I need a file dialog that will allow the user to Select a CSV file that resides in a Specific Directory.   How would I add this control to a form?  Do I need to add references and components?

2.  I need to extract data from the selected file to store in another table.    What is the best way to extract data from a CSV?

Thanks in Advance
KF
0
keithflash
Asked:
keithflash
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
There is no equivalent to the Common Dialog control in Access. You can use the FileDialog object, or use API calls:

http://www.mvps.org/access/api/api0001.htm

Access offers the TransferText method, if you can work with it. Many devs use this method to move the CSV data to a temporary table in Access, then use SQL to move the data to the "live" tables (after checking it for consistncy, validation, etc). There's also menu/ribbon items which allow you to import external data.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now