What is best way to copy data from a .dbf to MS Access .mdb file?

microsoft.public.dotnet.framework.adonet

22 Apr 2006 4:51 PM

RajSB

Iam writing an appln in VB.NET using VStudio.NET Express.

1. I have an MS Access mdb with a table called "tbl_one"
2. I have another database in foxpro format .dbf called "tbl_two"
3. I need to do few comparisons between tbl_one and tbl_two.
4. So I thought it will be easy if I can do copy of "tbl_two" to MS Access
as new table and then do a comparison.
5. How Can I do a copy of the entire dbf into MS Access in VB.NET
programmatically?

Thanks in Adv.

--
RajSB

24 Apr 2006 5:14 PM

Cindy Winegarden

Hi RajSB,

It sounds like you're after program code that will import or link a table
into an MDB. Have you considered posting to an Access newsgroup?

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegar***@msn.com www.cindywinegarden.com

Show quote

"RajSB" <Ra***@discussions.microsoft.com> wrote in message
news:D3E6BA6E-8BB3-4B2F-BF09-647A839EFCF9@microsoft.com...

> 5. How Can I do a copy of the entire dbf into MS Access in VB.NET
> programmatically?