importing dbf to accdr file
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Original .dbf table designer says it's because it contains memo field that contains text.
I can't change/redesign table because its part of application that uses it as it is.
Importing table (to access or excel) works but particular field stays empty. Importing is also unacceptable because I need access to fresh data, all doe I have another purpose for it also.
Can this be helped?
At this point I'd be grateful if I could link it with memo field empted (like with import),
but it would be great if its data would be accessible to
When I try to do the exact same thing with the other dbf, I get a message that says "the Microsoft Office Access database engine could not find the object CDCompTitle.dbf" and to make sure it exists and is spelled correctly.
Since I clicked the browse button to get there it IS there and IS spelledcorrectly.
I've been searching online for a few days with no results. Several responses to others with this problem said the dbf file is corrupted. I took my dbf (which works with no problem in Approach) and exported to a new file and got the same results on the new file.
After doing the compact and repair,the option "Visual foxpro database" which previously used to appear in the Machine Data tab vanished!I use this option for importing a dbf file (largesize) to access.The option is like
Open Access-> go to tables->Click New->Imort Table->ODBC Databases(Files of type)->Machine Data Source
Now the option "Visual foxpro database" is not appearing in the Machine Data Source tab without which I will not be able to import the dbf
I work in a Citrix environment and the access application is accessible only via that.The access version is Access 2000
My onsite counterpart tried to restore the access application to some oldest working version.In the morning when I tried to import the option "Visual Foxpro Database" was there.However wheni tried the same thing in the evening to the same application,that option disappeared.Strange!
I don't know how to import a dbf alternatively.
I have read that it has something to do with the length of the field so I edited field length from 255 down to 100. Still I am having the same error. What can I do with this?
I've been searching online for a few days with no results. Several responses to others with this problem said the dbf file is corrupted. I took my dbf (which works with no problem in Approach) and exported to a new file and got the same results on the new file. Other suggestions were about the Jet Engine, updates, etc. but I have SP 2 for Office 2007 and I think that's the latest
I've done it many times before but this time it doesn't seem to work , and I don't know why.
You will see on the first printscreen of the attachment, When I configure my connection, I choose the directory of the table and I see all of them including dp.dbf and dpadd.dbf. Then when I click OK twice and now I see the screen to actually link my table (2nd printscreen). The tables dp.dbf and dpadd.dbf do not show anymore.
I'm using access 2007 but I tried it with access 2003 and 2000
Foxpro driver used is VFPODBC.msi. All the dbf seems to be the same
I can import that .DBF file into Access just fine, but cannot figure out how to export (or "Save As"?) a .MDB. I've seen posts online involving "Tables" but I can barely navigate Access and no idea what 90% of all those buttons do.
Private Sub Command61_Click()
Dim access As access.Application
Set access = CurrentProject.Application
access.DoCmd.OpenQuery "MASTER DBF QUERY"
access.DoCmd.TransferDatabase acExport, "dBASE IV", "c:\", acTable, "MASTER DBF QUERY", "MASTER.DBF"
DoCmd.Close acQuery, "MASTER DBF QUERY"
Now in 2007 it no longer works. Does anyone have