Importing Access Data into a Paradox table

[woodyinoz]

I have written the following code in an attempt to automatically copy data from and Access table into a Paradox table:-

method pushButton(var eventInfo Event)
var
dtHandle DataTransfer ;// handle to transfer variable
tvTable TableView ;// tmp handle for displaying imported file
endVar

;// Set notification for user
setMouseShape(MOUSEWAIT, TRUE)

dtHandle.setSource "C:\\WINDOWS\\Desktop\\LittleFolder\\TestStuff\\material.mdb", dtASCIIVar)
dtHandle.setSourceCharSet(dtANSI)

;// Enable the key violation and problems tables
;//
dtHandle.setKeyViol(TRUE)
dtHandle.setProblems(TRUE)


;// We are always appending in this script since we force
;// the destination table to always exist
;//
dtHandle.setDest("MatMan.DB&quot
dtHandle.setAppend(TRUE)

;// Perform the import
;//
dtHandle.transferData()

;// Reset cursor for the user
;//
setMouseShape(MOUSEARROW, TRUE)

;// Display table
;//
tvTable.open("MatMan.DB&quot

endMethod

However, this code returns the following error - "Corrupt file - Other than header". Despite recieving this message I know that the file is not actually corrupt so am looking either for an alternative way of doing this or any suggestions as to why my code is reulsting in this error.

Thanks,

Woody.

 

[woodyinoz]

As an additional point - this error message only occurs when the Access file has been moved from its original directory. When run from its original directory the error message "Table Busy" is reported (which is correct because the table is always in use by another application). Why is this?

Woody.

 

[jlockley]

No idea. I think you asked elswhere about exporting to Access. I don't see the need for it, but I just came across the following transfer product.

http://www.zdnet.com/downloads/stories/info/0,10615,73183,00.html

 

[Langley]

I assume you are getting this error when you try to display the table at the end of the script, but have you set a breakpoint and stepped through the script to make sure? Another question is: did you try to open the "Matman.db" file in native Paradox to see if it is actually corrupt?

Mac
Mac

 

[Bystander]

Woody,

As an alternative solution you could just create an ODBC link then capture the table structure and contents via either QBE or SQL?

Regards

Bystander