importing different files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form that needs to be able to accept different DB files and
put only the Zip field into a holding table in order to run queries. Right
now I have a textbox on the form to enter the file name. I am trying to
write VB code to take the file that was entered into the textbox and import
only the "Zip" field into the holding table.
This might not be the best way to do this. Any suggestions?
 
Do all the files have tables that are named the same and include a field named ZIP?

What kind of FILES are we talking about? Text files, Excel Files, Access
Databases, word files?

If you are talking about tables, then are they in different databases?
 
These are dBase files. Not all the tables have ALL the same fields, but they
all have a ZIP field. Yes the tables are in different databases. So far I
have used TransferDatabase method, using a variable for the path that was
entered into the textbox, but I get an error message saying the path is not a
valid path, but I know it is.
 
Whoa!

Sorry, I've lost this thread for some reason. Looking back over it I don't see
that I have a solution for it given the limited amount of information. I
apologize for leaving you without a response. I know that a solution could be
coded, but it would require more time than I am able to devote on a volunteer
basis to the solution. IF this is important to you, then you might see if you
can engage a professional (not me) to help you develop a solution. A wild guess
is that this would require a couple of hours to develop, test, and deliver. If
there are unknown or unexpected complexities then the amount of time and the
cost would go up.

If you are using VBA to do this, you might post the code to the Access
'modulesdaovba' forum and see if you can get help there. If you do, please
point out specifically where the code fails or what it fails to do.
 
Back
Top