.net - Bulk Importing Text Files / VB2005 / SQL Server 2005?
Aug 12, 2011
I've inherited a .NET app to support / enhance which reads in a couple of files of high hundreds of thousands of rows, and one of millions of row.The original developer left me code like :-
For Each ModelListRow As String In ModelListDataArray
If ModelListRow.Trim.Length = 0 Or ModelListRow.Contains(",") = False Then
GoTo SKIP_ROW
[code].....
and it takes an age (well, nearly half an hour) to import these files.
View 2 Replies
ADVERTISEMENT
Nov 11, 2009
I need to dump a bunch of delimited data to Excel. In VB6 days, I would save the data to a text file, then use ExcelApp.ActiveSheet.QueryTables.Add (blah blah blah...) to import the data to Excel (I got this code from recording a macro while manually importing a text file).In VB.NET (2005), QueryTables does not appear to be an option for ActiveSheet.I could take the long path and manually parse thru the data writing to individual cells - however if I could just import it, it would be much faster.Part of the issue is not being able to record a macro in Excel in .NET format.So my primary question is, how do I import a delimited text file in to Excel without having to manually parse the data into individual cells.Secondary question is any tips for not being able to have ready made examples (in VB .NET format) by recording a macro.
View 3 Replies
Nov 1, 2010
I would like to make bulk insert from .txt file to SQL server 2005. here is the format of the text file?
Decoding CDR from file DCRC2118.RCP1.num2 (121148 bytes) in binary mode detax.pld ** d:/wf/perl.exe #5.00402Article # 0 ticket # 14D 04 00 01 00 FF FF 21 FF 10 04 21 07 09 25 00 00 01 04 21 07 09 25 09 35 63 36 03 13 56 39 17 03 00 00 07 91 25 27 91 09 57 1F 08 63 77 10 17 90 12 28 6F 07 91 25 27 90 10 02 0F 07 91 25 27 90 10 00 0F 07 63 7F 71 00 65 28 FC 00 00 00 ++Ticket length
[code].....
View 2 Replies
Jan 3, 2012
I am working on a desktop application in VB.Net (4.0) There will a lot of SQL scripts which contains a lot of insert queries Currenlty we are running the scripts using SMO (http://msdn.microsoft.com/en-us/library/ms162557.aspx)For performance, we have planned to change the sql scripts to xml file ( instead of insert queries, it will have xml data with a proper xsd defined )Loads xml to dataSet and Using SQL Bulk Copy we are trying to insert to SQL Server.
[Code]...
View 1 Replies
May 5, 2009
I have been given a task to create a new billing system for my company and I have been trying to get the customers from one Access 2000 database into the SQL Server 2005 table
Public Sub IPCustomers()
Dim rtn As Integer
Dim OLEDBConn1 As New
[Code].....
The problem lies in the strSQL where you see dbo_Libraries.LibDescription.Value and dbo_Libraries.LibID.Value.
Before, I merely put single quotes around the fields from the from the Access Table and it inserted exactly the code itself, dbo_Libraries.LibDescription.Value and dbo_Libraries.LibID.Value , and only 1 record. There are over 300 records in the table.
When I put double quotes around both, separating them out from the string I get the error "Arguments Not Set."
View 4 Replies
Dec 8, 2009
Ok where am I messing up here, I had this working to a local SQL 2005 instance. However I am unable to get this to work to a remote SQL instance. Why?
[Code]...
View 16 Replies
Oct 19, 2011
i'm using windows 7 home . and i want start sql server 2005 (SQLEXPRESS) with VB2005. but i can't find command about this thing
View 1 Replies
Aug 27, 2007
I am working on vb2005 with sql server 2005. How to get the messages generated by sql and display them in vb?
View 3 Replies
Sep 10, 2009
I barely know VB at all, but I managed to build an application with it, to import some text files into a database. So my problem that is left is that I need to install the application on the server and setup the scheduled task. I have the setup project built, but I can't figure out how to publish it so I can put it onto a CD. I am working in Visual Studio 2005.
View 1 Replies
Aug 20, 2009
I am try to import a text file read it's hex code search for a specific string and replace it with a different string. and write the changed file. I so far have a why to browse for the file on my form but not sure what to do from there.A
Public Class Form1
Public fdlg As OpenFileDialog = New OpenFileDialog()
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
[Code].....
View 9 Replies
Mar 18, 2011
how to best go about this project. I have just been given the task of creating a program that will primarily be used to import and sum a excel or text file that is tab delimited. As a quick example the file would be in the following format:[URL]The problem is that I would need to store this information locally (unless you know better) because I need to be able to append information to this from a second (or third, fourth, etc...) file and re-sum it, lets say that this is the second excel file that I needed to sum:
[URL]
I would have to append the week5 and week6 columns and add the Neapolitan row to my summation. This program will then format the sums into a list of the different flavors and the sums of all products sold during the total weeks and output to a text file.I have informed my employer that it would be easiest to do this with a VB script in excel, however, they are adamant that they want this done in VB.NET with a GUI.
View 4 Replies
Dec 4, 2009
i need upload bulk of files using ftp so don't need to loging each time i should loging 1 time then upload all of my files then close the connection
View 1 Replies
Aug 23, 2011
I am trying to import a bunch of excel 2003 files all with A:H columns and they are under the same headings etc. into a table in access 2003 database. This is a module in access im making. Im using a file search to look for every file that begins with Format (which they all do ) to get at all the files in the folder path. is there a more efficient way to do this? somehow select all files in a folder? and import each to the same table in access? The DoCmd.TransferSpreadsheet seeems to take each file path individually so I'm not sure how to get each file name in the folder to import it.
I have this at the moment:
Sub Import()
Dim db As Database
Set db = CurrentDb
[Code].....
View 1 Replies
Mar 9, 2010
I have VB.net console application which is working fine locally. It should start once I double click it.I created a setup project (using Setup and Deployment wizard) and publish it on the server, it does not work. It just flashes and then goes away.Would there be any dependencies I'm overlooking?
I included during my setup-
Primary output from 'myapp'
Source files from 'myapp'
Debug Symbols from 'myapp'
I even tried to add the exe (which works on my machine separately on the server, but does the same.
View 3 Replies
Aug 25, 2011
Here is what i am doing as of now...
For i As Integer = 0 To Dt1.Rows.Count - 1
Cmd.CommandText = "UPDATE Spares SET Pur_Price=" &
Dt1.Rows(i)("Cost_Price") & ",Sell_Price=" &
[Code].....
However this procedure is very time consuming, i need to optimize it. I need to update 20000 rows ...
View 2 Replies
Dec 14, 2010
I'm doing a project where we are re-creating a very old system.The client wants the same base functionality and some improvements.One of the things I'm currently working on is the note-system. These are used as flags of some sort, but are also used as a comment field for some products or client profiles.In the old system you could write the text and save it like you would get in a .txt file. They want the new one to be able to do word formatting such as:
Different font sizes (Only some parts of the text)
Different font colours (Only some parts of the text)
Underlining of words
Bolding
Italics
Tab-spaces
Those are the specs they want. What I need to know is the following:
1) How do I do that?
2) Currently they store all these files on the server as text files and the database have paths that refers to each file. I want to be able to save a text file with that formatting to the HDD of the server like in the old system.
3) If possible I would like to save that text to the database with the formatting.
View 1 Replies
Aug 7, 2010
I have stored an excel file within an SQL Server Table having the corresponding column data type as varbinary (MAX) through a VB .NET windows application form. how can I retrieve and open the stored excel file for manipulation?
View 2 Replies
Mar 26, 2009
I use VB.net to create a Windows Service . its job is to connect a server ( for exemple \10.10.10.10ox named P: and collect files .but the problem is the result of mapping the server ( Dir P: = "" ) return nothing i don't find my files !!!Do i have to use the ftp in windows service ?? because when i use a windows form apllication there is no problems and I find all the files
View 3 Replies
Jul 18, 2011
Is it possible to store excel, word, pdf, .rar .zip files to a column in a table of a SQL Server 2005 DB.And also open the fie with excel, word, acrobat reader, etc????My other sollution would be to store the file on a location on a server and only sory the filename and location in my db and then open them with "Process.Start("filename")".My main problem with solution 2 is this:Lets say I install the programm on a pc called "manager". When I use the savefiledialog and I am on the manager pc the string C:/myfiles/test.xls will be stored
View 1 Replies
Sep 6, 2009
find sample code to "read" a text file from a web server? This is the file: [URL]
I want to be able to evaluate if it contains some specified text... How can I refer to this file using VB.net and store it in a string variable?
Here's an example of what I want to do:
boolean aaa = false
'The following is located in the "tick" event handler of an activated timer with an interval of 600000 ms
[Code].....
I want to be remotely command all of my programs do something like this, all I have to do is to change the text in the text file to "now"
View 3 Replies
Jan 2, 2009
here is the poblem after installing the program only users can only use the program if they are logged as admin can use the progam. like writing to the database. i either need to find out how to change the users
to have write access during install or great a dll and add it to the install and as the program starts it checks the file and folder access of the users. if the access does not have write enabled then it runs the dll to fix it. not having any code posted i really do not have any idea how to do this. oh yes the short verision is if the program is install as an administritor only a user that have administritor access can write to the database.
View 1 Replies
Jan 28, 2010
Someone please explain this to me like you would to a complete idiot.I want to make a shaped form according to an image.The transparency key only works under 16 bit graphics and we all work on 32bit. Then the entire background shows.The clipping is also very un-neat.So how do you shape a form neatly according to an image WITHOUT using transparency key so it will work in all graphic modes?
View 5 Replies
Mar 4, 2009
I want to build a console app, that when ran, takes a report from one Access 2000 database and copies it over to another Access 2000 database and overwrites the existing report in the destination database. I cannot figure out how to do this in code. I have imported the Access 9.0 Object library, but still struggling.
View 2 Replies
Jun 8, 2011
"How to import or put Microsoft 3d Movie maker in VB 2008?"
I have searched in internet but got none.. I also tried to but I don't get it.
View 1 Replies
Jan 8, 2010
How can inserting picture to picture box from sql server database to vb.net2005 program at run time?
View 1 Replies
Mar 23, 2011
So my program allows people to download/upload text files from an FTP server... But... is this safe? I've always been a little scared with FTP because I fear that some lowlife is gonna hack into it. Is there another way to do this? Or is there a way to make this connection much safer?
View 5 Replies
Aug 7, 2009
I have inherited a VB.net web app that I'm making some changes on. I'm perfectly capable with the programming side (VB and MSSQL) but I'm getting lost with the tools. I was given a zip file of the code and everything. I opened the sln file in Visual Studio 2005 and it worked fairly easily with little modification.
Running the app works perfectly. Problem is, I need to write some new SPs so need the database admin. SQL Server 2008 Express is installed but it doesn't see any database and I have no idea how to import it.I have a folder App_Data in the project with the file ASPNETDB.MDF. Opening this in VS gived the error: This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later.
View 3 Replies
Aug 5, 2011
we're importing a lot of data to sql server from an MS Access db. we're doing it via a vb.net windows form. We open the Access db as a dataset, loop through it and save it to sql server with a stored procedure.
View 2 Replies
Sep 11, 2009
Im having strange problems when importing data from an excel file into a sql table. Everything seems to imports ok until i look at the data in more detail, this is when I notice its imported the data but in the wrong order. for some reason when I look at the db table all records are in the wrong order, and strangely enough it seems to be a different order every time I import things. Is there a way to force the routine to import the data in the same order as the it is in the excel file?, because at the minute it seems to have a mind of its own.
My code is below:
Public Function ReadExcelFile(ByVal sFileName As String) As Boolean
Dim oSQL As New clsSQLHolder
Dim excelCon As String
[CODE]........................
View 2 Replies
Sep 11, 2009
Im having strange problems when importing data from an excel file into a sql tableEverything seems to imports ok until i look at the data in more detail, this is when I notice its imported the data but in the wrong order.
View 3 Replies
