Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Need to get somewhere quick in Access 2007

Posted on 2011-03-04
1
339 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 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

856 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