Assistance With Migrating Text File To Access
Mar 5, 2009I created a program that logs incoming data to a serial device to a text file but the output is not what i really want, the data appends to the text file and looks like:
[Code]...
ADVERTISEMENT
Migrating From Access To SSCE?
Jan 4, 2012I have an application with databases in MS Access. I want to migrate that to SSCE. I have converted all the databases. Problem is with datasets.Do I need to make all new datasets or there is a way to convert the existing ones to SSCE datasets?
View 6 Replies.net - Migrating Application From Microsoft Access To VB Or C#.NET?
Sep 5, 2010I'm currently trying to convince management of the need to port one of our applications to .NET. The application has grown to be a bit of a monster in Access (backend in SQL), with 700 linked tables, 650 forms/subforms, 130 modules and 850 queries.
I pretty much know all the major benefits of doing this, but now need to look at how this can be achieved technically, so I can put a project plan together.So, my plan was to convert the queries into stored procedures and/or views on the backend and re-write the forms in WPF or WinForms.
Now, the code is where I come unstuck. Is it possible to packaged up the code behind and modules into dlls and consume them whilst it is slowly ported to VB/C#?
What we can't be left with is half an application in VB/C# and half in Access, it must 'appear' to all be one application, even half way through the migration.EDIT: Just some more info about what we do and why we're looking at moving away from Access.We are essentially an ISV and the Access application is our main product. This application has been developed over a period of 15 years, by many, many developers on an ad hoc basis. There is no documentation for this application.
We also have problems with getting branching in SCC to work properly, so we've currently got 4 or 5 code bases for the half a dozen clients we have. On top of that, all the testing we do is completely manual, which you can imagine is very labour intensive, and only scratches the surface of what really needs to be tested.We're currently looking to expand, and have a number of sales leads that are in the final stages. I'm worried that with these new sales, we're going to be swamped with support and testing, and that this application is going to become even more entangled an buggy.
I'll also add to this the fact that we're just about to enter the spec phase of a brand new product, which is almost certainly going to be built in .NET. If we were to rewrite the Access application in .NET, then the people we use for that can go straight on to this new development. If we were to stay in Access, then we'd have to get some new Access people in, whom would have to be retrained once we start the new development.
So essentially it has come down to two choices, major refactoring work in Access to try and 'organise' the code a bit better, and those of you who have suggested culling parts are most probably right; I'm sure there are parts that are no longer used. However, I fear that if we stay in Access we still won't be able to build in effective testing and we still won't have proper SCC branching, which will lead to support continuing to be a nightmare, and any future developments on this product makings things worse. Either way there is a lot of work that we're about to embark on, which is either going to be done in Acces, or .NET.
DB/Reporting :: Migrating Access Database To MS SQL?
Jul 16, 2009I need to update a database app written in VB, Visual Studio 2003, using an Access Database.Currently: Customer has 4 users, local network. Access Database is 30MB, about 50 tables.Wanted: Customer is opening new offices, and wants to connect to the database via the internet. There will be 10-15 users.App background: I have all data access via OleDbDataAdapters and one OleDbDataConnection.There are 4 DataSets: Global, Lookup, Reports, FormSpecific.
I have one Private function: FillTable:
Private Function FillTable(ByVal TableToFill As DataTable, _
Optional ByVal OleDbAdpToUse As OleDb.OleDbDataAdapter = Nothing) As Integer
' fills the table by using OleDbDataAdapter.Fill(aTable)
[code]...
All is working well.What I Need to Do:I think I need to migrate the Access Database to MS SQL. What I Have:Visual Studio 2008 Professional. I have started the MS SQL walkthroughs. I did the �Create a Data Connection to the Northwind Database� walkthrough, and connected via MS SQL Server. I cannot find where I can modify the SQL Commands. If I convert my Access Database to a MS SQL Database then can I
1) Just update the OleDbConnection, so it connects to the MS SQL Database (not the Access database).
2) If I cannot do #1, what do I need to start with?
Migrating MS-ACCESS 2003 To DotNet
Nov 17, 2011Would like to migrate MS-ACCESS 2003 legacy applications into modern Dot Net, including migration of the MS-ACCESS Database to Sql Server 2008 (with potentially also migration of the MS-ACCESS Reports to Sql Server Reports). The purpose is to move to DotNet application with Sql Server as its database.
[Code]....
SQL Server - Migrating From Access To SSCE
Jan 4, 2012I have an application with databases in MS Access. I want to migrate that to SSCE. I have converted all the databases. Problem is with datasets. Do I need to make all new datasets or there is a way to convert the existing ones to SSCE datasets?
View 1 RepliesNeed Assistance With Method Of Converting To Specific Column Locations To A File
Aug 21, 2009I am looking for any assistance on the best method to accomplish this task. I need to take a comma delimited text file, load it into memory, and then grab indevidual columns of data and export them to a file.[code]I need to for this project I ma working on grab ALL of COL C for example and export it and the data to that column to a file. Can someone provide me with assistance on the best and easiest method on doing this? I know I can do it with a lot of parse text's and many methods of using a listbox or arrays but I'd like to explore some options.
View 6 RepliesFile I/O And Registry :: Random Access File Larger Than Text File?
Jan 7, 2009I am writing a program to calculate Pi to several hundred billion decimal places and this will require lots of GB of memory. I wrote a test program in VB2008 that saved the first 16 digits of Pi (without the decimal point) to both a text file and a random access file, just to be sure it was outputting the numbers properly. For reference the first 16 digits of Pi are:
View 8 RepliesConverting Delimited Text File To Access File?
Jul 29, 2009I've got a problem in Importing Text delimited File to access Db , I always get an error "No value given for one or more required parameters' while execution [Select Into] Statement
[LEFT]
Dim svdialog As New SaveFileDialog
svdialog.Filter = "Access Database Files (*.mdb)|*.mdb"
[Code]....
Access Text File From Web With .Net?
Jan 16, 2010I'm trying to load a text file with VB .Net so that I can use it with a streamreader object. for example:[URL].. It is of a particular URL and is already present on the server
View 2 RepliesAssistance With ASP/VB6/RDS --> .NET Conversion?
Feb 9, 2010I'm currently working for a client who owns a custom developed ASP/VB6/SQL2k5 3-tiered web application... The application has been developed over the course of 10 years by several different companies... I have a team who is in the process of rewriting components of this application over to a ASP.NET/C# applications, leaving the structure of the back end database in its current state (ie: no redesign of the database)... As you know, this is a very long tedious process when performed correctly... Our client is looking for a "wizard" type conversion tool or process instead of the redesign of the web UI and business objects... Several people on my team (including my architect and I) continue to tell our client this is not possible, that a full rewrite of the application is required... Can someone just validate my thoughts on this? Here are some of the technical specifications of the legacy application:
· VB COM objects are heavily reliant upon ADOR recordsets
· ~150k lines of VB code spread across 6 COM objects
[code]....
Exporting From Access To Text File?
Apr 29, 2010this is my problem: i've some data in an access database, i collect this data from the table and when i try to record the data in the text file, with the fields separated with a "!",the registration fails, better, doesn't register all the datas that are in the table.This is the
Dim tw As TextWriter = File.AppendText(Application.StartupPath & "DStampa.csv")
Dim objDataTable As DataTable
Dim TotaleDatiStampa As String = ""
[code].....
Random Access Text File?
Apr 25, 2010I'm doing a Program for a Friend of mine, He Want to have a Console Program Running on his Computer.OK the problem i am having is With Stream Read, I have 3 test users inside Test File, if User 1 logs in his information is store in logged file with time and data.but if User 3 logs on user 1 2 and 3 are all saved on the logged file
i dont have read to end of file in my Code.i dont have my Program with me, so i going off the top of my head i have something like this what i want to be able to find out how to do is Right from any part of the file and out put it, I take it i need to use Random Access but how to i code Random Access for this type of file. All i can find is how to Randomly place Words in a text file with Length and size.
[Code]...
Error When Trying To Convert Text File To Access
Dec 3, 2011I am trying to insert data from a text file into an Access table. However, when I try to execute the command, I keep getting the following exception:A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll.And my Catch block throws me the "Unable to read file" error that I placed.[code]
View 4 RepliesExport Access Table Into Text File?
Jan 10, 2012I have written the following code to export an MS access table into a text file.
Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Test est.mdb")
Dim cmd As OleDbCommand
[Code]....
Importing A Text File Into Access Database?
Nov 12, 2010I am using the following code to try and import a txt file into an Access database however it is not working, at all. The txt file has approximately 10 columns in it but when this has finished I get 1 column with no Data.
[Code]...
Importing Text Delimited File To Access Db?
Jul 29, 2009I've got a problem in Importing Text delimited File to access Db , I always get an error "No value given for one or more required parameters'while execution [Select Into] Statement
[LEFT] Dim svdialog As New SaveFileDialog svdialog.Filter = "Access Database Files (*.mdb)/*.mdb" If svdialog.ShowDialog = Windows.Forms.DialogResult.Cancel Then Exit Function
[Code]....
Save Access Table To Text File?
Jun 15, 2009i have a comma delimitted text file that i need to add three fields and update the contents of those three fields and then save the text file.
right now i bring the file into ms access and alter the table to add the fields and then update them but i don't know how to export the access table back into a comma delimitted text file.
Trying To Connect Field From Text File To Access DB
Mar 23, 2011I am working on a project for work where I am stuck. We have a daily checklist that i have converted into a Tabular text file. In the text file I have 3 pieces of information, DB field reference, Time it should be done by, and task to be completed. I have this part being pulled into the screen with the Code below. My problem is how do I Merge the Database to the TextBox. The Access DB has 50 Columns of for data Labeled 1 through 50 + one date Field
Imports System.IO
Public Class FirstShiftCheckListForm
Dim strlines() As String
Dim strline() As String
Dim strarray(,) As String
[Code] ......
.net - Assistance With TCP Reverse Connection?
Jul 3, 2010I am creating an authentication server for some projects I'm working on. This authentication server works by receiving and transmitting data to users trying to authenticate. The user can send data to the server succesfully but when sending back it requires port forwarding. I read a way that I would not require port forwarding by using reverse connection but I have no idea how to get it working. I found a tutorial and tried to implement but when it tries to connect to read the stream it says the connection is refused.
View 1 RepliesAssistance With Input Variables?
Mar 24, 2010Basically all it is is a program that outputs a file with variables users input.I'm having a big problem getting the input variables into the correct places. I suppose I can't tie them in. For example.I have a textbox labeled textbox1 and I want to use the input from textbox1 in the code below
xWrite.Writeline("The Value is" & textbox1 & "for field 1")
Game Of Pig Code Assistance
Feb 14, 2012I need assistance with a program we have to do in programming class. It is due soon and I am stuck on how to code it and if the extra button is necessary or not. The game is called the Pig Game where each turn, a player repeatedly rolls a die until either a 1 is rolled or the player holds and scores the sum of the rolls (i.e. the turn total). At any time during a player's turn, the player is faced with two options:roll - If the player rolls a
1- the player scores nothing and it becomes the next player's turn.
2 -the number is added to the player's turn total and the player's turn continues.hold - The turn total is added to the player's score and it becomes the next player's turn.The first player to score 100 or more points wins. More info is here: url...
I have no idea where to go from my current position. I think I coded most of it though. I will attach the files in a zip folder for all to see my form and code.The main problem here is: I just need the code to be fixed, so it works and so I don't fail the class. Attaching the new version in a zip file would be nice but you don't have to do that, or you could just tell me the code and form layout directly on here!
Possible To Create Loop Assistance?
May 6, 2011seriously struggling with this one bit of a program im creating. Im trying to simulate a moving queue, using a number of pictureboxes (controlled by Timers). Once a picturebox vanishes, another appears in front of it to symbolise movement throughout the queue.Anway... Im struggling with LOOPS! I cant seem to make the funtions repeat and I need this urgent due to a deadline in 16 hours time Background Info: The form will run for 60 seconds, after which anotehr form will loads (MorrisonsQueueSummary).Here is the syntax so far:vb.net
Public Class morrisons
Private Sub FormTimer_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MainTimer.Tick
[code]....
Remote Assistance For VB 2010?
Mar 7, 2012Ok, here is the scoop. I would like to know if someone would provide remote assistance in restoring contols for visual basic ultimate 2010. I have had this version for less than a week and the controls are dispapearing to make it function. I don't know how to restore functions yet, due to the fact of beginners luck.
View 2 RepliesVS 2008 New Application Assistance
Oct 20, 2010First off I'd like to say I'm very new to all of this VB world, .........so with that being said I'm trying to develop an app that will allow the customer to choose how they would like to have a Vehicle Customized.
[Code]...
.net - Exclusive Access To Text File, To Read And Overwrite It?
Oct 20, 2010I'd like to open a text file and not allow any other processes to write to it. I understand I can do this with the following FileStream:Dim fs As New FileStream(_FilePath, FileMode.Open, FileAccess.ReadWrite, FileShare.Read)
Once I have access like this I need to read all of the lines (I will use a StreamReader(fs)) and then I will need to write to the file (I will use a StreamWriter(fs)).
The problem here is that the StreamWriter won't allow me to set the append mode to false (so I can overwrite all text in the file) when I use the filestream as a parameter instead of the file path. So all text written with the StreamWriter is appended onto the text which I don't want. If I use a StreamWriter with the file path (which will let me set append to false) as the parameter instead of the filestream it will be locked out because of the FileStream FileShare. How can I still have exclusive access to read and write to the file but still be able to overwrite the existing text (append mode false)?
Application Slow Is DB Access/text File Code Ok?
Jan 26, 2012I noticed that my application is running a bit slow. This is a Windows Service built using VB2010 with SQL Server as a back end. Its main function is to poll a folder looking for a text file. If found it reads the text file and imports the data into SQL Server.
While the slowness could be caused by a number of reasons, I am looking at my code to determine if it could be more efficient. Below I've pasted snippets of code where I initialize the DB connection and execute SQL statements. I've also included a snippet that illustrates how I am processing the text file.
I'd appreciate if the group could have a look at these and let me know if the method that I am using is the most efficient possible. At this time I am also focusing on other probable issues, but I can't rule out the possibility that the code that is in place might be a contributing factor.
[Code]...
DB/Reporting :: Import From Text File To Database (access)
Nov 10, 2009I am trying to import a text file to an access database in VB2008 express. The text file I am testing with is a csv file with 34,000 records. The problem is this takes 2 minutes to read through all this and write it to the database. The actual text file I will be using in production has over 800,000 records and this will take a ridiculous amount of time. I think I am doing something wrong. I have posted my code below. I am reading a record, parsing out the fields to an array, then creating an SQL statement to insert the record and executing it.
reader = New IO.StreamReader(fname)
Do While reader.Peek() >= 0
linesread = linesread + 1
[Code].....
Export Microsoft Access Database To Text File?
Aug 7, 2009I'm using Visual Basic Express 2008 (VB.NEt). I've created a project which
connect to a Microsoft Access Database (OLEDB) & displays the records using textboxes in the windows app.
I need to add a button which exports the database to a fixed length text file. Does anyone know the code I would use to do this?
Import Csv Text File Into Existing Access Table
Aug 18, 2011I'm using the following code to import data from a text file into an existing Access table:
Code:
Imports System.Data.OleDb
Public Class Carrega_CSV
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]....
The first time i ran the code, it caused no error but no records where loaded into the table. The second time it causes the OleDbException "Table 'TEMP' already exists." The text file is comma delimited and it has exactly the same number of columns of the TEMP table.