I can't financially, but mentally I retired already. What 60-year careers could look like: thank you! I am ready to retire right now. Full Stop! Ready to work until you are 80? IT & Tech Careers

Ives and FAQ, where you can find a lot of info. For more information about this you can perform a search in the arch= U the ability to manipulate (special formatting, cutting a part of it, et= Ing on your text file (and it requires you to write the code) it gives yo= (each line contains the same number of records) and that you know which p=Īrt of your txt file goes to which field.Īlthough, the above might take longer to run (not much just a bit) depend= Since you are using vb, you might want to try the following: Http:/ Opens a new window / r/ da.asp? r=80566 Opens a new window Migrating to VB.NET: A case study using relative debugging Http:/ Opens a new window / r/ da.asp? r=101449 Opens a new window Http:/ Opens a new window / r/ da.asp? r=80609 Opens a new windowĭeveloping Applications with Microsoft Visual Basic and Pervasive.SQL 2000i *- RELATED WHITE PAPERS -ĭeveloping Custom Windows Controls Using Visual Basic. Also take some time to learn some basic SQL syntax if you are not familiar with it. Solution above was tested before post so from my point of view what you should do is just copy-paste the code, and modify db.path, text file name, text file directory. Take some time and visit to learn how to open a connection on various databases. If this is not what are you looking for, see solutions other have posted.

requires a reference to Microsoft AciveX Data Objects 2.1 or higher.

'to insert values into an existing table, use following queryĬn.Execute 'INSERT INTO table2 SELECT * FROM. ' To insert values into a new table use following queryĬn.Execute 'SELECT * INTO table1 FROM. If my database is C:db.mdb, and my text file is C:test.txt then use the following code to import text file into database:Ĭn.Open 'Provider=.4.0 Data Source=C:db.mdb' I see you are not reading the posts on this forum, beacuse there were about 2 or 3 copy-paste solutions to your problem posted in the past 2 weeks.

File drag and drop vb6