Importing dbf file

[Danielf]

Hi,

I would like to import a *.Dbf file in a new table in my program. The problem is that I don't need to import all the records but only those from record 120 till 180.


Could somebody help me please.

Thanks

Daniel

 

[aikea]

Import source table as linked. Create an append query in target database that filters the records and add records to target table.

If the source table records can be sorted. You can sort those records then use "Top #" sql statement to select a number of rows.

 

[Danielf]

Import source table as linked. Create an append query in target database that filters the records and add records to target table.

If the source table records can be sorted. You can sort those records then use "Top #" sql statement to select a number of rows.

Thanks for your answer but I have still another problem:

I am trying to import a DBF file from this directory:
"c:\Internet\Download" . the name of the file is "Peardat.dbf" and the name of the table in access should be Peardat .

The command is oCmd.TransferDatabase , "dbase IV", "C:\internet\download\peardat.dbf", , "peardat1"

BUT I am always receiving the following message:
C:\internet\download\peardat.dbf is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Of course the path and the name of the file are correct and I am connected ( it is on my own computer- without network)

Daniel

 

[aikea]

Thanks for your answer but I have still another problem:

I am trying to import a DBF file from this directory:
"c:\Internet\Download" . the name of the file is "Peardat.dbf" and the name of the table in access should be Peardat .

The command is oCmd.TransferDatabase , "dbase IV", "C:\internet\download\peardat.dbf", , "peardat1"

BUT I am always receiving the following message:
C:\internet\download\peardat.dbf is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

Of course the path and the name of the file are correct and I am connected ( it is on my own computer- without network)

Daniel

Try this:

DoCmd.TransferDatabase acImport, "dBase IV", "C:\internet\download\peardat.dbf", acTable, "peardat", "peardat", False

 

[Danielf]

Hi Aikea,

No, it doesn't work.

I still have the same error message.

Daniel

 

[Rabbie]

Just a suggestion. Have you tried accessing the .dbf file as a linked table?

 

[aikea]

That's completely defeat me. You may wish to try to port all of your file to a new machine and try it again to see what happen.