looking for canned VBA code for import module 1

[only412c]

I am looking for VBA code to run import interface. I want the user to select type type of data to import, filename and path from directory to import(enter in text or searchable by income that calls directory and drive). Please let me know if you have as I have to implement this right away. Thank in advance. User will import text files and excel files to Access using this interface screen.

 

[only412c]

Need of VB canned code to import data into access from Excel or Text files.

Clarification: I meant let the user allow to key enter filename and path in text box or select an icon next to the text box to get to the directory drive where import file lies. A screen would serve as the interface between user and system.

e.g.

User will select one of the two radio button option
Payee information
Bank information

Then user will enter the import file name and path to determine where VB will look for file. or User can search for the file by pressing a open file button


Last the user would press import file button to store import data into Access table.

 

[psemianonymous]

Since you know exactly what you need, it would be quickest for you if you just grabbed a common dialog API module or used the CommonDialog OCX in your form, which allows the user to "browse" for a file. Then create your own form (as you have described!). Other than that, you seem to have it all in hand. Good work.


Pete

PS--there are FAQs on how to get the common dialog boxes, but the easiest way is probably to grab the code from that other thread titled "Common Dialog"

 

[only412c]

Thank you Pete,

I am a little rusty since I just got into Access a few months ago. All along was creating form, interfaces, reports etc. thorugh the design interface of Access. I am now getting in the VBA administrator for the users started to demand more. Know of any good books to get so I can understand much of the method you have describe. I have done programming years years years ago under DOS and have only work with implementation of user requirements since then. However,somehow I've gotten much interest in designing applications. So back to programming I GO GO.


P.S. My company does not offer any training but want the product. What a bummer.... [purple]

 

[psemianonymous]

1. As for books, I am of no help. Everyone recommends the "Access [version number] Developer's Handbook" by Ken Getz and others. It is considered advanced topics. I get my Access 97 copy sometime next week, so this is all secondhand information, but it is quite highly recommended all around.

2. If you're desperate you can check out the Northwind example db installed somewhere on your machine. It may get you more comfortable with Access/VBA and application building in general. Or maybe not.


That covers the main angles of learning, besides oral tradition. Good luck to you.