VB/FoXProTables

[jbrown99]

well in that case where have you been?:)

well i'm very new to foxpro. i have foxpro
tables that i would like to use. Is there
a way for me to use vb and append a text file
into the foxpro table without having to loop
through the text file? what i want to do is something
like "select the foxpro table append from text.file"
i know this is done in a matter of seconds using foxpro
but can this same method be used from vb.

i found out you can pack a table using ado and i'm
sure there is more.

any good resources on this?? vb/foxpro tables?

any info would be great thanks

jason

[dcarlson]

I saw your post before and wasn't sure how to do what you want.

You can issue commands throught the execute method of your connection like Pack.

Now, I don't think it will work in your case because when you append like that your table is in the data session of the FoxPro environment. I'm sure you must have tried the execute method and it didn't work, otherwise you wouldn't have post this thread.

As for Resources I've not found any really. It's all trial and error on my part which really sucks. You can try searching for VB/dBase resources also.

Sorry I'm not much help here.

[jbrown99]

ya thats what i been doing trial and error
and the execute did not work thanks anyways :)
the projects are working just fine in foxpro so
thats where they will stay :)

thanks
jason