i am importing a csv file into my app. this is to let the users pull in info they have in excel.somehow, they have slanted apostrophes, and not tick marks. so when i open the file stream and do the import, it pulls in those characters as blank boxes (unknown char).
View 1 RepliesI wish to import data (into a text box) from specified tags within an XML file.[code]Instead of loading the whole file into a text box I would like it to load data within <ABC></ABC> tags.The amount of <ABC></ABC> tags varies for each XML file. As does their placement (which line they are on).
View 2 RepliesIs this possible? I upgraded to VB Express 8 and have several programs that I would like to import into VB Express 8 from VBE 5. But everything I have tried so far has not worked.....This is the first time I have imported files from one computer to another. I have tried to save the file as a zip file and unzipping it in VB 8, but that didn't seem to work.
View 4 RepliesI have a datagridview on my form with 7 columns and a variable number of rows. It's used to track stats on games (kills, deaths, assists, etc.) The way I ended up saving it was in a .xls file for the simplicity of being able to edit it in excel as well as my program. how to import the file back into the DataGridView though.
Here's the code I'm using the save the file:
VB.NET
Private Sub exportExcel(ByVal grdView As DataGridView, ByVal fileName As String, _
ByVal fileExtension As String, ByVal filePath As String)
' Choose the path, name, and extension for the Excel file
[Code]....
I want to create a button that will open up a form that will be used to browse a filesystem and select an excel sheet to import into access. I'm a noob at .Net and I needsome help on how to do this.
View 4 RepliesI am working on a program for the Windows Mobile 6.0 system and using Visual Basic 08.I would like for the current txt file that I have, that is formatted as follows: "NOR400","277225","ZIMA 4/6 12OZ NR BOTTLES","07199077603",21.65,"cs",7.19,"pk","C4/6PK","12 OZ " to be imported and each item in the line will be assigned to its own txt box. I have been able to load up the file, in to one txt box, but am unable to separate the items in to their own box. Should I be using arrays for this?
View 6 RepliesWhen i run the following line of code I only get the first part of the XML file imported into Access.
Application.ImportXML DataSource:="http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml", ImportOptions:=acStructureAndData
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.
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]........................
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 RepliesI wish to modify a pre-existing procedure to import just the first four out of five columns from an Excel .xls file, which may be viewed as a "physical file" on the local hard drive.
[Code]...
I can't seem to get the code structure I'm looking for when importing a csv file into an array. The CSV format in question is 69 columns, and unknown rows since it depends on the time length of the data capture. Over the past 3 days I have tried many methods and can output it all to a listbox, as shown below (column headers appear in order), however when I try to put it into an array it only reads the first column. Am I missing something in the declaration of the array, or do I need to use an arraylist? Every permutation doesn't seem to get the results I seek, or I just plain crash the program.
[Code]...
I'm sure this is a common problem but I have been unable to find a good solution anywhere.I am using line.Split to read a CSV file.Unfortunately the data contains strings that have comma's in them like so:
"Singer","Hasselhoff, David",21,15
This results in 5 strings:
Singer
[code]....
I had this code working to import one column in a table as a starter point, but now that i'm trying to import all the columns in the table, i'm running into problems.
When I run the app, I get this Microsoft . NET Framework error:
Syntax error in INSERT INTO statement
I've tried just about every combination I can think of for the sql statement and still the same error message.
Imports System.IO
Imports System.Data.OleDb
Public Class Update2
[Code]....
I use the following code to import a XML file into an Access database:
dbname = "c:PC Auditer.accdb"
xmlFile = strFileName
Dim ds As New DataSet
Dim streamRead As New System.IO.FileStream(strFileName, System.IO.FileMode.Open)
ds.ReadXml(streamRead)
streamRead.Close()
[Code] .....
The import works fine, but when a next XML file is imported with less records, the database don't get updated and the 'old' records remain in the database.
When the connections is successful (which it does when ran). Button 1 Writes to the text file (which it does successfully). Button 2 deletes the contents of the table and not the table itself (which it does successfully). Last, button 3 is supposed to read the text file and insert each field which is separated by a comma back into the existing table. However, at the "addComm.ExecuteNonQuery()" step I receive an error (An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll). I have spent many hours trying to find a solution but can't seem to get it to rewrite the text file back to the table.[code]...
View 13 RepliesWhen importing data from excel to vb.net desktop application, Im having "file is open" error. Excel file is at the remote pc. Excel file must open and I have to reach anytime. How can I handle this problem?
View 2 RepliesI'm brand new to this forum. i have a question. i wrote some software a while back and now have a few new features I need to implement. this software currently makes use of "application settings" to store all of it's settings. Which works just fine.
I have a client that has about 40 users. He wants to be able to share his settings (that he set up in his copy of the software) with all of users. Preferably by distributing a copy of a config file that they would be able to import into there software.
The issue I have is being able to import a batch file (text file) into a vb form. I have test data for a system in this text file that needs importing into a textbox on a form. I have a button named importbutton that when pressed, will import this file into the text area, that contains over 30 rows worth of data. (Data being single sentences related to IT issues).
View 3 RepliesI 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]...
the problem i met is that i have iis 7 running on my pc.in the root file, wwwroot, i have a website folder, namely [apex] which is a virtual directory. in the folder is a bin folder containing a compiled class with namespace.then in an aspx file, i tried to import the namespace and use the class inside the namespace.
[code]...
the namespace and classname has been checked well, no mistake. but at compiling stage, i got "type is not defined " message. ok,then, in iis 7 control panel, i convert the whole website folder from "virtual directory" to "application" type. the problem goes away!
I'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]....
I am doing system to read text file it contain numbers and I want to read this data to multi array , the description as :-
This site here :-
DataSet format
My data looks like that :-
20 3 10
10
10
10
0
0
0
0
0
1
1
1
1
1
0
1
0
Code: Attached File(s)
Dataset.txt (246.44K)
Number of downloads: 30
I am working on a program for the Windows Mobile 6.0 system and using Visual Basic 08. I would like for the current txt file that I have, that is formatted as follows: "NOR400","277225","ZIMA 4/6 12OZ NR BOTTLES","07199077603",21.65,"cs",7.19,"pk","C4/6PK","12 OZ "
to be imported and each item in the line will be assigned to its own txt box. I have been able to load up the file, in to one txt box, but am unable to separate the items in to their own box. Should I be using arrays for this?
I have a procedure that imports data from Excel file. Something like this:
Public Sub ImportExcel(sFileName As String)
Dim xlsApp As New Microsoft.Office.Interop.Excel.Application
Dim nRow As Integer = 2
xlsApp.Workbooks.Open(sFileName)
[Code] .....
If user opens excel while procedure is running, then the procedure will use the excel sheet opened by user and not the one that was using before user opened Excel ...
I am importing a txt file containing 4 columns of numbers and storing the values into an array, however occasionly there is a line of text that reqires skipping at the start of the text file. I will probably use a textbox or checkbox to say how many/if any lines sohuld be skipped.
[code]....
I am trying to import a .csv file exported from google contacts into a textbox in VB.net. For some reason characters such as © ¥ ¤ ¶ turns out as when imported. [code]
View 3 RepliesI want to export data from a DataGridView to a CSV/text file. I then also want to be able to load that same CSV/text file and populate that same DataGridView at a later point in time. My information is loaded into columns in the DataGridView. That is, I am not using rows to represent records, I am using columns. As such, I need to load all the data in each column and export this, by column to the CSV/Text file. Likewise, when I load the control from the CSV/text file, I need to load each column with this information.How do you export/import from/to a DataGridView controlHow do you organize the data in the CSV/File
View 5 RepliesI have to read in several thousand lines of a EDI 4010 or 5010 formatted file into a database. This is medical claims data. In my current process I read each row of the file and parse it into a string array. I then assign each value of the array to a string variable and when I detect a new claim header or detail record I write the variables to the SQL server in a SQL insert statement. Example below
[Code]...
I'm trying to get a local HTML file to display within a WebBrowser in a VB.NET program. I'm using the code below, however it doesn't seem to work, and I can't figure out why:[code]The first method produces the error "" in the Debug console when I go to run it. If I try it with out the @, I get an empty white page. If I change the address, however ,so I know its a broken URL, I get a 404 message, which makes it seem like it's finding the file but not rendering it?The second method does the same as the first except no error is produced, its like its finding the text but doing nothing.
View 1 Replies