General discussion

Locked

join multiple access tablein vb data bin

By Jhinrich ·
I have a text file to import into access that is 510,000 line long. to do this i have to split the file into multiple table. hit all tables in VB6.0 using a data-binding link to that table in access

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

join multiple access tablein vb data bin

by keith.hall1 In reply to join multiple access tabl ...

In theory, providing you've created a link to the tables in Access, and that you give each table the same column names with the same datatype for each column, you can recreate the original table with a Union query e.g.
"SELECT * FROM tbltable1 UNION SELECT * FROM tbltable2 UNION SELECT * FROM tbltable3"
Call it qryUnion

Then create a Make-Table query with this query to create a new Table tblFull
"SELECT qryUnion.* INTO tblFull
FROM qryUnion;"
You can now delete the links to the originaltext files.
This will work in practice, but I don't know how robust ot will be in Access with 510000 records?? Otherwise you will need to step through each line for each table, and addnew then update with the recordsets.

Collapse -

join multiple access tablein vb data bin

by Jhinrich In reply to join multiple access tabl ...

Poster rated this answer

Collapse -

join multiple access tablein vb data bin

by Jhinrich In reply to join multiple access tabl ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums