hi,

I am developing a VB application using ACCESS 2000 on WIN 2K.I require to 
save my final output in the FOXPRO Dbf file.I create a new DBf file for 
each output.

I am using DAO 3.6 reference and the following Code:

    Dim DB1 as Database
    
    Set DB1 = Workspaces(0).OpenDatabase("D:\master.mdb")

    sqlCreateDBF = "SELECT * INTO [dBase IV;DATABASE=d:\].[Batch1] FROM 
[ClientEntry]"

    DB1.Execute sqlCreateDBF


The Batch1.DBF file is being created.But not all the fields are getting 
displayed.Some of the fields are dispalyed as "MEMO" and to view the 
values for that field ,i have to docuble click that field.

Any idea why this is happening??

Any help wud be appreciated......

regds,
ashay