Using text file as database in vb6

Create a data access layer interface and three separate implementations. One for a text file, one for SQL, one for Mongo. Compare and contrast your experiences with them. Look into SQLite. It will be faster than parsing and converting k records from a text file. Going down a NoSql or Standard Sql path depends on the needs of your software, with the limited info you have given its difficult to tell you which path to take.

Will there be only one table for the life of your application? Do you plan on updating the records in the file? DavidStampher: Any statistic like that is going to be meaningless unless the implementation specifically applies to what you're doing.

Hammers are 10X better at hammering nails than screwdrivers are, but they're pretty useless at driving screws. Show 13 more comments. Active Oldest Votes. DavidStampher Even though you may be using just one table or file, I would strongly suggest using a database system for this. Let me know if you have questions. Improve this answer. Sometowngeek Sometowngeek 6 6 silver badges 26 26 bronze badges. Examples: Append text to existing table, import text as new table. Path folder for demonstration : [Import.

Improve this answer. Bob77 Bob77 13k 1 1 gold badge 26 26 silver badges 37 37 bronze badges. Richard Harrison Richard Harrison Richard, in VB6, can we import such a text file into Access database directly without replacing space into comma, reading and inserting per record? Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The program is uses the Do Loop to read all the data until it reaches the end of the file by issuing the command Loop While Not EOF On the right is the whole program:. Description , , "Please create a new file" create. The path will default to the xyz server upon which my project instance is running but will allow the user to navigate to any other mapped drive.

I am new to this job.. Thanks in advance Radhakrishnan vrradhakrishnan gmail. Follow Post Reply. Hemant Pathak 92 Expert. I have the following sql statement that I use right now to export a database table into an excel spreadsheet using an automation process. Unfortunantly not all can be exported as excel files and instead need to be exported as a text file with tab delimitations. Can anyone help me change the sql statement I included below to make it instead export to a tab delimited text file.

You help is welcomed. EOF Then rs. RecordCount rs.