I have uploaded a sta file in de www folder at our Windows 2003 Server, but nobody can download this file. The message "The page cannot be found" appears. I'm sure the path is correct. I replace the sta file by a txt file, and that works. So, it seems to be a security issue... Does somebody has...
Hi,
I made an Access-application (Access 2003) that uses pivotcharts. Because not everybody has Access, I made a runtime version of my project.
But I see that the list view (the list with the fields from the table/query on witch the pivot chart is based) is not available in an Access runtime...
Hi,
I made an access project in access 2003. Some people in our company works with Office 2000. In my project, there are some important Pivot charts. I see, Pivot features are not available in Office 2000 and we can't install Office 2003 on their computer.
May be their exists some thing like an...
Hi,
I made a program "Article administration". In the main window I show a list of my articles. When I double click on an article, you can edit them. It is also possible to add new articles.
When you edit or add an article, the list in the main window has to be refreshed after closing the...
Hi,
I have a strange problem. I wrote an import procedure to import data from an Excel file. It worked already without any problem. Today, I want to do the same import and it doesn't work anymore... :-s
this is my code:
Dim myDT As New DataTable("Artikels")
Dim excelConnection As New...
Hi,
How can I use an IFF in my select clause.
I have a column VAT_NUMBER (nvarchar(50)) in my Table. I want an extra column in the result of my query. If the VAT_NUMBER is not null then return 1 otherwise return a 0.
(I use SQL Server 2000)
SELECT
NAME,VAT_NUMBER, ???VAT_NUMBER_YN???
FROM...
I want to receive the last Unique Identifier from a table.
I have already this code:
Dim myCommand As New OleDbCommand("Select max(Id) as LastId from Translation", OleDbConnection2)
OleDbConnection2.Open()
Dim myReader As OleDbDataReader =...
To get te records from the Excel file, you have to use "Select * from [sheet1$]".
Thx for your useful tip.
But once I have my data in the DataAdapter...
Is it possible to write the DataAdapter at once to the SQL server?
I have already tried it, but it doesn't work. I use the Update() method. ->...
Hi,
I want to write a tool in VB.NET to import data from an Excel file and write it to a SQL-Server.
Does somebody has any experience with this topic?
What is the best way to do this?
Thx,
Bart
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.