Data unreadable after importing DBF into acess 2003

DBF database imported into access 2003 is done successfully ,but the data are rubbish ,any idea
AJDeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Haris DulicIT ArchitectCommented:
do you need to import it as you can manipulate with it without importing...

http://www.motobit.com/tips/detpg_asp-dbf-database/

if you want it in your database can you create table and then

insert into New_table
select * from DBF




AJDeveloperAuthor Commented:
Actually ,yes i need the importing ,but if use the query ,then i must refer to the location of the DB ?
Haris DulicIT ArchitectCommented:
yes if you are going to query it you need to refer to the location ...

since the access import is giving you trouble than maybe this could be workaround...
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

AJDeveloperAuthor Commented:
Can you please list the steps to do that ,i now try to open the DBF file ,it gives me back error ,that MS Jet engine is not finding the object
Haris DulicIT ArchitectCommented:
here is the snipplet how to open and get count from the dbf..

could you try it... just to check is it working with your dbf
Private Sub Command0_Click()
Dim Conn: Set Conn = CreateObject("ADODB.Connection")
Dim rst As Recordset
Set rst = New ADODB.Recordset
 
  Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                   "Data Source=C:\dbf\;" & _
                   "Extended Properties=""DBASE IV;"";"
  Set OpenDBFConn = Conn
 
 rst.Open "select count(*)as x from [test#DBF]", Conn
 
  MsgBox rst!x
  
End Sub

Open in new window

AJDeveloperAuthor Commented:
thanks for the code but why Im receiving the error that MS jet enginer can not find object (DataBaseName0
Haris DulicIT ArchitectCommented:
can you paste you code and path to your dbf file...
Jim P.Commented:
In Access 2000 and above they locked out a lot of direct linking to DBase/Foxpro databases.

Have you tried creating an ODBC connection to the DBF file(s) and then linking them via the ODBC?
AJDeveloperAuthor Commented:
No ,actully what im doing i have the db on my desktop and then I open the access and create a new db and them from import from external source ,then I get the error
Jim P.Commented:
>> No ,actully what im doing i have the db on my desktop ....

It is stupid, but TPTB at M$ decreed it needed to be done this way. Create an ODBC connection to the dBase files using the Microsoft dBase Driver or  Microsoft dBase VFP Driver and then link using the ODBC call and you should be able to import fine.
AJDeveloperAuthor Commented:
I think there is nothing stupid about this ,it is simple ,a user is experiencing this issue ,and I want to know why this issue happens in the way ,and why the import process is generating that error,anyway i will try what you advised and let u know
AJDeveloperAuthor Commented:
hi again ,sorry for the delay ,I tired the code ,but it gives me error ,I really appreciate if someone could provide me with all the steps form A to Z to import the dbf programatically or at least me let me know what went wrong in the import

Cheers
AJDeveloperAuthor Commented:
and more interesting ,is that i can import the file to excel with no issue ,please help
AJDeveloperAuthor Commented:
The file name has space and I made it one word ,but im getting another '
External table is not in the expected format. (Error 3274) '
AJDeveloperAuthor Commented:
anybody please help on the above
Jim P.Commented:
Do you have the table linked in? If you change the columns or index order, you have to delete the link and then link it back in.
AJDeveloperAuthor Commented:
The table is not linked and i dont know how i can the columns if I cant import it
AJDeveloperAuthor Commented:
My last post was before 2 weeks and still didnt get any feedback ,is there a problem with the site
Jim P.Commented:
>> External table is not in the expected format. (Error 3274) '

Let's start from scratch: From the ODBC Administrator (Start--> Run --> ODBCAD32.exe) create a System DSN(s) for the Foxpro files you want to import.

Then after you create the ODBC, go into the Access DB and Right-Click in the database window and select Link Tables. Then in the files of type select ODBC databases. It will bring up the dialog and then select the link/tables you want.

From there you should be able to read them.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AJDeveloperAuthor Commented:
Perfect ,it works ,thanks alot
Jim P.Commented:
Glad to be of assistance. May all your days get brighter and brighter.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.