with VB.NET + ACE 12.0 + MS office 2003.
my connection string is
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Fx & _
";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1';"
[code].....
I am having problems reading an Excel file using ADODB.connection.[code]I do NOT get the error if I have my Excel file open at the time. Does the Excel file have to be open for this type of connection to work?
View 16 RepliesI have a problem with open connection to Excel file. I use this open connection:
[Code]....
I use Excel 2007 to open the file and there is an error message "The file you are trying to open is in a different format than specified by the file extension. Verify that file is not corrupted and is from a trusted source before opening the file." I don't know what is wrong with my code to create and save data to excel file ?? Or maybe something is wrong with my open connection?
I am trying to read from a .dbf file in vb.net.This is my code.I am getting the following error.
OleDbException was caught: External table is not in the expected format.
Error in Detail:
System.Data.OleDb.OleDbException: External table is not in the expected format.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
[code]....
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" + fileName + "'; Extended Properties=Excel 5.0"
Dim ExcelConnection As System.Data.OleDb.OleDbConnection
ExcelConnection = New System.Data.OleDb.OleDbConnection(ConnectionString)
[code]....
Error occurs on line
ExcelConnection.Open() External table is not in the expected format.
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" + fileName + "'; Extended Properties=Excel 5.0"
Dim ExcelConnection As System.Data.OleDb.OleDbConnection
ExcelConnection = New System.Data.OleDb.OleDbConnection(ConnectionString)
Error occurs on line ExcelConnection.Open()External table is not in the expected format.
I have a program that is connecting to an Excel file using ADO.Net. It processes some html files and parses out certain pieces of data and enters it into the spreadsheet (either updating the record with recent data if the record already exists, or adding a new record if not). It seems like it works fine and I can process several html files successfully. But every once in a while the program will crash with the error that the "External Table not in Expected Format". When this happens, all I have to do is exit out of my program, open up the spreadsheet file in Excel, save the file, close Excel, and restart my program. Then I am able to continue processing files including the file that I was trying to parse when the program crashed.
The Spreadsheet is in Excel 2003 format, but I am using Office 2010, however when I am saving the spreadsheet I never get any boxes popping up about possible compatibility issues. I also don't have to do anything to the spreadsheet when I've opened it in Excel expect to resave it. Not sure if anyone has heard of this issue before or how I could possibly fix it.... If anyone needs code, I can post it, although because my program seems to function correctly most of the time, I don't think that there is an error there...
i am trying to insert date in dd/mm/yy format in sql table from a textbox but everytime the default date 01/01/00 goes in table.
View 19 Repliesi'm using VB.Net 2005 application program.i'm trying to convert VB6 code to VB.Net 2005. QSockB is DLL file.this is the code i used for VB6. This is code i'm using to create socket, when program runs... and when i hit start button it calls Q_SendHeader function.
Form1_Load(.....................
Q_KDSPort = &H8000&
Q_MyPort = Q_KDSPort + &H100&
[code]....
This works fine in VB6... but Q_SendHeader is not working in VB.Net 2005.
i want to link an externel table to an ms access database through vb.net. Is this possible. I am able to create a new database and a new table is created.
View 1 RepliesProgram : my game is a frogger port, you make the frog cross the road until you run out of lives. When you die, you are asked to enter your name and the name is appended to the end of file called names.txt, the final score is appended to the end of a file called scores.txt.Using the System.IO functions, i read the contents of each text file, and load the contents into two separate strings (one for names, one for scores. These two long strings are then broken down using Split() command, transferring the pieces into an array. (again 2 arrays - one for names, one for scores). The contents of both arrays are then loaded into 2 listboxes, 1 for scores, 1 for names.
Problem: i can sucessfully load the contents of both files, and display them side by side - but i want to re-arrange the scores so that they are in descending order. While doing this, i need to make sure that the player name matches up with the score - so the order of the names being displayed would have to be changed aswell. After spending many, many hours trying to do it myself i have had to give up - i'm clueless. My first issue is converting the score array into integers so that the array could be sorted, the second problem is then sorting the names so that the scores and names match up.
I'd like to move my images / icons and wav files (basically, almost all of my internal resources) from an existing project (VB 2005) and put them in an external dll, then reference this from my exe and call the relevant resource as required.
What would be the best way of doing this?I understand that I should create a ClassLibrary and put my resources in that, but how should I expose those resources to an external program and how should I reference and call the dll from my exe?
I've done some searching, but not found anything that seems to explain the process adequately enough.
I know how to check for the version information from inside a VB2005 application:
Dim version as String= String.Format("Version {0}", My.Application.Info.Version.ToString)
That works fine. But let's say I have two applications, A and B. App A wants to find out what app B's version is. Is there a way to do that?
I am working on a project inwhich I want same date format in all project forms. I want to use a form for setting/resetting date format for whole project. whenever I will change date format in this settings form, there should be this new date format available in all forms. how can I implement this?
View 8 RepliesMy code worked find until new .NET(?).Using word interop code (Word 2003) to make word do a mail merge via VB.NET code. I need to search and replace some string. Now this has worked fine before but now whenever the code reaches assigning the string value to the .Selection.Find.Text or .Selection.Find.Replacement.Text it stops dead with SEHexception external component causing error - see full error below.
[Code]...
[Code]...
I have been looking at the ADO tutorial on this site and am trying to apply it to my own DB. When I run the code above I get this error Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
VB has created the following code:
Partial
Public Class AwardsDataSet
Partial Class RevExpDataTable
[code]....
I am not sure of the command for format the Table 'Revenue' column for currency. Also is there a way to do calculations? I need to multiply the value by -1?
It's probably a long shot, but is there an add-in for VS2010 that can change VS2010's default formatting rules? In particular, I'd like to format similar lines so that the commas line up vertically, creating a tabular look. If it could line up equal signs, that'd be better still.In this case, I'm populating a dictionary with methods to translate a flat file into an object.
Parsers = New Dictionary(Of String, Action(Of String))()
This is a pain to read:
Parsers.Add("Aircraft Make and Model", Sub(value) Aircraft.Name = value)
Parsers.Add("Words/Frame", Sub(value) Aircraft.WordsPerSubframe = Integer.Parse(value))
Parsers.Add("Bits/Word", Sub(value) Aircraft.BitsPerWord = Integer.Parse(value))[code]......
I am developing windows application. Now I have got the data in the data set . Now I need that to be displayed in the table format, not in the grid.but in the table format as we get in web applications.Is it possible to achieve it? If so how could it be archived?
View 1 RepliesI have a sql server table with 2 cols. text, image. and i want to display these in a gridview or any table format. but i want pics to appear like this:[URL]..pics are side by side. how do i achieve this in vb.net.there will be 100s of pics and i need paging functionality too.
View 2 RepliesI guess I just cant seem understand this correctly
Dim StatusClosed As String = Form11.Closed_Code.Text ' usually = S or ClosedSale or Closed Sale
Dim SubjId As String = Form10.add_Num_txt.Text ' usually = StreetName or Street Name or SN[code]....
If SubjId is StreetNumber or SN its ok , if its Street Number with the space I get error
If I place a ' around {3} in my afilter line then it works if the SubjId is Street Number but not StreetNumber or SN
First I tried getting a SQL query into an array, and then mail it. Made the data incomprehendable. So someone told me to use CSS to build a table format, filling it with the array. A LOT of hard work (since I had to learn css all the way from "what is a css".
Then I was told "Array? why use array when DATATABLES are soooo much easier"
So here we go again. "What is a datatable, and how does it work"
I have Attactments in a old access Database table that I need to show to the user in VB.net. After doing everything we can think of we been looking for days and found this and starting putting it back togerther.
But at this point it is telling me {"Unrecognized database format 'F:\CLSINC\WORD\CLS programmer\CLS Helpdesk.accdb'."} db = dbEngine.OpenDatabase("F:\CLSINC\WORD\CLS programmer\CLS Helpdesk.accdb", False, False, "")
CODE:
I have a table in ms access. I need it to be imported to the Datagridview in vb 2010 in customized format . The below shown is my access table.
-------------------------------------------------------------
| ID | Names player | Sports |
-------------------------------------------------------------
| 1 | aleksy | rugby |
[code].....
I need the output in desired format as shown in image2. Check the attachment. This should work for any number of records.
have made the data table in vb code, and it works flawlessly. It gets its values from labels which are part of a calculation.It shows the information to the user in a datagridview. Now i would like it to add new rows and fill them in if the user has already entered the data once and it has been logged in the datagridview.here is the current
'DATA TABLE
Dim Table1 As DataTable
Table1 = New DataTable("CF Log")
[code].....
1. When I try to do something like; Imports System.Collections
[Code]...
I am using ms-access 2002. I have to export the data of a ms-access table in Fixed Width format. To accomplish this I am using DoCmd.TransferText method.
DoCmd.TransferText acExportFixed, "schema.ini", "table_ABC", "C: estingTestData.txt"
But I am getting error message: "Run time error-3625 The text file specification 'schema.ini' does not exist.You cannot import, export, or link using the specification."
Here schema.ini is at same location as of text file. i.e. "C: esting"
I tried with
DoCmd.TransferText acExportFixed, "C: estingschema.ini", "table_ABC", C: estingTestData.txt"
but no success.
For delimited format it is working fine
DoCmd.TransferText acExportDelim, "", "VDMMEMBS", "C: estingTestData.txt"
I have gone through the link [URL]
Error message is same as of me but example shown is related to import of txt file.
I have insert a data which is in binary format into sql server database table Column type of table is Image Type. I have to read this column from a XML file,I am able to read but
[Code]...
I am trying to make my program print out a requistion slip but I don't want to make a report using VB b/c sometimes the printer is not connected and it is better to have a Microsoft Word document and save it as such. So how do I create a Word application from VB? I basically am going to set out a format, make a small table etc. and then whatever the user types in the textbox, it will appear in the slip. (I am using Word 2003)
View 1 RepliesI am trying to figure out how to add a theme to my excel worksheet before saving it. I have found this code to change the cell color but have yet to find anything to change to a pre-default excel table format (the Table style light 2 theme)
[Code]...
How can i just select all the cells and place that Table style light 2 onto them all using VB.net?