473,320 Members | 1,817 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Error : External table is not in the expected format..????

Hi, I'm having problem to read *.DBF (DBase File) using ASP.NET.
Below is my code, taken from one of forumer here....

Dim connection As OleDbConnection
Dim command As OleDbCommand
Dim reader As OleDbDataReader

connection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; "&_
"Data Source=C:\;Extended Properties=dBase IV")
connection.Open()
command = New OleDbCommand("select * from FileName.DBF", connection)

reader = command.ExecuteReader() 'The error as subject above occured
after execute this line......

connection.Close()

reader = command.ExecuteReader()
listnews.DataSource = reader
listnews.DataBind()
reader.Close()
command.Dispose()
connection.Close()

Testing using Ms Access (Ms Access 2002) File->Get External Data >
Import with no luck...same error message.....

Using ODBC with
Microsoft DBase Driver
Microsoft DBase VFP Driver
Microsoft FoxPro Driver
Microsoft FoxPro VFP Driver...also no luck

Free Table Directory ....also no luck..

What else....... :(

Please help me..!!!!!!If someone interested I will send to your email
sample *.DBF file ...87 kb. I'm using Windows XP Pro...

Thanks in Advance
MeeR
Nov 18 '05 #1
0 3219

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Aidan Tobin | last post by:
I am trying to import a protected spreadsheet to an access database, I have 2 machines one running Win 2K and one running NT 4. It works fine on the 2K machine but when I try to import on the NT...
1
by: Edward S | last post by:
Friends, I had posted this on "Microsoft.Public.Access", But I did not get a satisfactory response. I have been struggling for nearly 2 days trying to crack this code. I really need help, could...
0
by: Learner | last post by:
Gurus, I have a C# .NET Web application that downloads a datagrid to an Excel sheet. But when I upload the same excel sheet to server again, if gives me this wiered message "External table is...
9
by: Trent | last post by:
Here is the error while using Visual Studio 2005 Error 1 error LNK2019: unresolved external symbol "void __cdecl print(int,int,int,int,int,int,int,int)" (?print@@YAXHHHHHHHH@Z) referenced in...
0
japuentem
by: japuentem | last post by:
Hi all I am trying to create an axcel connection using the DTS excel connection but when I try to assign the excel document to the Excel Connection object, it return the following error: Error...
15
by: judge82 | last post by:
I made sure I closed all the bracket, why do i still get the error. on line 360, 424, 425 and 607 Please help /* * ShopCartServletHW3.java *
6
by: tony.abbitt | last post by:
I have recently installed Office 2007 (SP1) retaining the previous installation of Office 2003. I have converted an Access 2003 database to Access 2007. The database contains the VBA code...
2
by: vijayrvs | last post by:
SearchCrawler.java The program search crawler used to search the files from the website. From the following program i got 7 compiler error. can any body clarify it and provide me solution. ...
2
by: smadadi | last post by:
When i am exporting the result of a query to an excel file it is comming up with the message "external table isn't in the expected format" It is happening occasionnally not everytime. I am using...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.