Solved

Append text to DBF File in VB.net ala "Append From" FoxPro command

Posted on 2008-10-06
6
2,393 Views
Last Modified: 2013-11-24
Hi!! I am attempting to append text into a dbf of the same layout through VB.NET.

In foxPro I would use the "APPEND FROM mytable.txt delimited with tab" command for a tab delimited file for example and foxpro will append the text into the correct fields as long as the schema is identical.

Does anyone know how to do this though VB? I normally would use the Access .COM object and just do this in SQL but there is no equivelent to the FoxPro "Append From text" command that I know of in SQL

any help is appreciated
0
Comment
Question by:ND_2007
6 Comments
 
LVL 12

Expert Comment

by:jrbbldr
ID: 22654711
"Does anyone know how to do this though VB?"

While I don't doubt that there are gurus here who know VB in addition to VFP, why do you think that this is a question for a FP/VFP forum?     There is no question here regarding FP/VFP code or FP/VFP application development.

Maybe you should try posting your question to a forum related to your VB question.
0
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 22654745
an sql equivalent to append from is insert into table from (subquery), and it's suported by VFP9. While it needs a vfp source for the subquery, that source can be a cursor created by remote dta acess.

You may alos simply use what you know: foxpro's append from command, via oledb provider. If you store whatever source you have in VB to another dbf or tab delimited text file or some other formats supported by append.

Bye, Olaf
0
 
LVL 27

Accepted Solution

by:
CaptainCyril earned 250 total points
ID: 22656769
If you have VFP installed on the computer, you can use automation.

oGreatestDevelopmentTool = CREATEOBJECT("VisualFoxPro.Application")
WITH oGreatestDevelopmentTool
    .DoCmn("USE path\table")
    .DoCmn("APPEND FROM file.txt TYPE DELIMITED")
ENDWITH
RELEASE oGreatestDevelopmentTool

You can also open two SQLSTRINGCONNECTION in VB. One for the text file and one for the dbf. Read from one and append to the other. In FoxPro you can do that in one command also using SQLEXEC. I don't know how to do that in VB. I gave up on VB back in 1996 when I saw that working with databases in it is like scratching your left ear with your right hand.
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 1

Author Closing Comment

by:ND_2007
ID: 31503609
thanks! - the automation was exactly what i was looking for.
0
 
LVL 1

Author Comment

by:ND_2007
ID: 22658955
Here's what ended up working for me. Much thanks to CaptainCyril and and everyone that responded

Dim oVFP = CreateObject("VisualFoxPro.Application")
With oVFP
                .DoCmd("USE " & sDBFpath)
                .DoCmd("APPEND FROM " & sTXTpath & " TYPE DELIMITED")
                oVFP.docmd("CLOSE ALL")
End With
oVFP = Nothing
0
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 22659620
Perhaps add an oVFP.Quit() before setting it Nothing. Else you're not quitting the VFP session, you'd find a vfp exe in the taks manager processes tab.

Bye, Olaf.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question