Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Need to get somewhere quick in Access 2007

Posted on 2011-03-04
1
Medium Priority
?
378 Views
Last Modified: 2012-06-27
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
Comment
Question by:keithflash
1 Comment
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 35038729
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question