VB - non-interactive way of creating database from text file

H

Hilton

Hi,

My last question was not phrased well so here it is again:

I have a text file I cannot import into DBASE / Paradox at 1 attempt. I
usually chop the text file up into smaller segments, import it, and then
append all the database tables into1 database table.Sometimes when it is
obvious the tables will total more than 2gig then 1 or 2 database fields
are deleted. MS Access can import text file in 1 attempt but even MS Access
has this 2gig limitation. Correct?

Questions:
Can VB be used to circumvent this segmentation approach?
If so how does one load a text file into a database file? - sample code
would do
Is DBASE / Paradox / MS Access acceptable or are there better databases to
use - especially when one reaches the 2gig cap?
 
G

Gord Dibben

You are posting in an MS Excel news group.

Probably not the best NG to address problems with DBASE and text files.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problems importing a Paradox file into Access 2003 4
Unexpected error from external database driver (8961) 0
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
Import text file to access database via Excel VBA. 1
Import text file to access database via Excel VBA 1
Import errors importing Text into existing table, header vs no hea 3
Creating an Access database file from a dbf (dbase) file 5
VBA to export "Clipboard" data to text file 8

Top