Combining Access Tables in Visual Basic
I've been working for two days to find a technique that exports data
from VB into DBF format. If you stick with DAO, you should be OK. I'm
using ADO and am still searching for the best answer.
I think what you're trying to do can be accomplished with either tool.
As you probably know, if you go with VB you don't need MS Access on the
client machine(s). MS Access would make importing and exporting a bit
easier, however. Importing and exporting can still be done in VB, it
will just take a little more code.
If you go with VB, mark this site for future reference:
http://www.smithvoice.com/vb5expt.htm
BTW, I've been thinking about trying netzero. I'm interested to know
what you think about the service.
Good luck,
Joe
Quote:
> I am writing an application in VB6 that has to interact with several
Access
> tables in different *.mdb files(multiple Access files containing
multiple
> tables). Programmatically, all the different tables must be accessed
and
> combined into one, and then exported/converted to a XBase DBF Table.
> I would like to know if using Access to create this application would
be
> more practical. I would prefer to use VB6. If VB6 is a practical
solution,
> how would I go about accessing info in the several different Access
files?
> Would I use ADO(control or code), DAO, etc... ?
> Also, later on, I will have to pull columns/records in from a spaced
> delimited text file. I added this in just in case that would
determine if I
> used Access or VB6.
> Speedy replies are encouraged.
> Thanks,
> Courtney
Sent via Deja.com http://www.deja.com/
Before you buy.
