Problem with importing dbf flat file

[jkfeagle]

I'm having a real time finding a way to import a dbf flat file into a table. It's effectively a spreadsheet but I can't use TransferSpreadsheet because it doesn't recognize the file type but when I use TransferDatabase, I don't know what table name (from) to use. I've tried it using the worksheet name as the table name but it doesn't work. What's more peculiar is that when I try to use the TransferDatabase method, it tells me I have an invalid path entered even after I've validated the path over and over again. Any ideas out there?

 

[Robert88]

Hi jkfeagle,

What type of dbf file is it? I have done this with a Fox Pro dbf.

I have read in dbf's but you also have to play around with your ODBC driver.

Check these two connections;

http://www.access-programmers.co.uk/forums/search.php?searchid=849582

Good Luck

Robert88

 

[jkfeagle]

Robert,

That link doesn't seem to work.

 

[Robert88]

Hi jkfeagle

Sorry about that, here try this link.

http://www.access-programmers.co.uk/forums/showthread.php?t=102185&highlight=Fox+Pro

I hope it helps.