keithflash
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.