Solved

Need to get somewhere quick in Access 2007

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

895 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now