Combining Access Tables in Visual Basic 
Author Message
 Combining Access Tables in Visual Basic

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



Sat, 13 Apr 2002 03:00:00 GMT
 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.


Sat, 13 Apr 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Combining Access Tables in Visual Basic

2. GA-Atlanta-98153--Visual Basic-MS ACCESS-RDBMS-ORACLE-Programmer-Visual Basic and Access

3. GA-Atlanta-98153--Visual Basic-MS ACCESS-RDBMS-ORACLE-Programmer-Visual Basic and Access

4. Combining Access in Visual Basic

5. access table updated by Visual Basic passed on to visual Foxpro

6. TX-HOUSTON-105339--Visual Basic-MS ACCESS-ORACLE-Web Development-Visual Basic Programmer/Analyst

7. TX-HOUSTON-105339--Visual Basic-MS ACCESS-ORACLE-Web Development-Visual Basic Programmer/Analyst

8. IL-Chicago-47740--Programming Skills-Visual Basic-ORACLE-DBMS-MS ACCESS-Programmer-Visual Basic + Oracle

9. NC-WILMINGTON-113234--Visual Basic-RDBMS-ORACLE-SYBASE-MS ACCESS-MS SQL Server-VISUAL BASIC/RDBMS

10. TX-HOUSTON-105339--Visual Basic-MS ACCESS-ORACLE-Web Development-Visual Basic Programmer/Analyst

11. IL-Chicago-47740--Programming Skills-Visual Basic-ORACLE-DBMS-MS ACCESS-Programmer-Visual Basic + Oracle


 
Powered by phpBB® Forum Software