I am just starting out and my boss has this project that I have to do. I have been searching but haven't found anything that can explain well for me to understand. Here is my project. I have 2 xls files that I need to read in. I need to create 2 new xls files from the read in data. Then add columns to each and write in data for those columns.
View 5 Replies
I want to read data (read only) from excel files
I use this connection string
Con_BarCode = New ADODB.Connection
With Con_BarCode
.ConnectionString = "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm,
[Code].....
I have many applications that create TLB files which I guess are so that vb2005 can comunicate with the DLL files. Now what I would like to do is have all my TLB files in one folder and have my application point to that folder to use them.The problem I am having is that my EXE will not run unless all the TLB files are in the same folder as the EXE. I do not want this. I want to put some code into my file that sais that the tlb files it needs are located in say: [code] and still have it work. again right now they all have to be in the same folder which is really bugging me.
View 3 RepliesI am creating a program that uses text files to recall data and store them in a variable. My intention is to make this text file hidden so it will be harder to find and for other people to edit the data inside. I'm looking for a code that enables me to write to the file without unhiding it.
View 5 Repliesi want to read/write to some files.Specifically my application searches text files but i also want it to search binary files. The problem is : how will i know when the file is binary and not text ? Also how will i get the hexademical contents of a binary file ?[URL]
View 2 RepliesOK I can upload a single specified file but need to create a loop to read and upload all files in a certain folder. Here is code for single file.
'upload a file
ftp.Upload("c: estftpupload.exe", "/pub/upload.exe")
I have 500 odd csv files that I need to pick up and load into a table in Teradata.How do I combine this 500 files data into one file Or is there a script that will go and fetch data from each file and load it into the table.Here are more details.I have a bunch of hotels and the end of each day all the hotels dump in one file into a common folder.
Like
D:CorpHOTELSACCOUNTSREPORTINGUSA
Here I get files in the following format.
Hotels_Sales_Graph_level_20080529
Hotels_Sales_Graph_level_20080530
Hotels_Sales_Graph_level_20080601
[code].....
Now I need a script to pick all these files data and load it into one file so that I can use this file to insert data into a table using a fast load script i already have.I have a script that will read this file copy it to a new location and archive it.I can use this final file to load my table.But I dont have a script to read all these files and also read the new file that comes in everyday and load it into one csv file.
Im building a project that reads data from a text file. Its in the format of an address book:
First Name
Last Name
Phone Number
I can read thae data in to an structure:
Public
Structure AddressRcd
Public userID
[Code].....
I have SQL 2005 table with columns TypeId(int) & Description(ntext datatype).
The Description column has XML file content as value in the table.
Now i want to read the data into a dataset in VB.Net. How to do it in VB.Net. I am using Winforms and VB.Net in VS 2005.
I have SQL 2005 table with columns TypeId(int) & Description(ntext datatype). The Description column has XML file content as value in the table. Now i want to read the data into a dataset in VB.Net. How to do it in VB.Net. I am using Winforms and VB.Net in VS 2005. Below i have given the xml file content.
<?xml version="1.0" encoding="Windows-1252" ?> - <SummaryPageComponent xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> - <categories>
[Code].....
I have a problem with my program. i can't read any data from serial port. when i click on open the rs232 has to read but it doesn't.i use the program in a pdf(ADAM-4000_Ed-15).[code]
View 3 Repliesi am using visual studio 2005 check my code and let me know what i am doing wrong
[Code]...
Can you maybe tell me what is wrong with this code?I get an error on the line were the writing is in red.
db.OpenConnection()
strSQL = "SELECT * FROM ChaletBookings WHERE BookingNo = '" & strBookingNo & "'"
dr = db.getData(strSQL)
[code].....
Basicly I want to create a server that can read data sent by multiply clients and give feedback to them I have found some tutorials before but its only oneway trafic (Client>>>>Server) and the server crashes as soon as the client is disconnected
ps. If its a tutorial with VB it will be nice other visual codes are also good
Question: How do I programmatically determine which provider to use (Microsoft.Jet.OLEDB.4.0 vs Microsoft.ACE.OLEDB.12.0) when my app runs as a 32-bit process on a machine with Office x64 installed?
I'm developing a VB.net WinForms app in VS 2010 and targeting both x86 and x64.The app processes data from xls, xlsx, mdb and accdb files using System.Data.OleDb:Dim oConn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=...")
The x64 version of the program works as expected. The x86 version works as expected on a system with Office x86.When I run the x86 version on a machine with Office 2010 x64, I get the following exception when trying to open a connection:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.I believe this is because I'm running Office 2010 x64 so the x86 data access components are not installed.I can get it to work for Office 2003 files (*.mdb and *.xls) by changing the provider to Microsoft.Jet.OLEDB.4.0.
How do I figure out which provider to use when running as a 32-bit process on a machine with Office x64 installed?Ideally, I'd like a function:If ProviderIsAvailableFor("Microsoft.ACE.OLEDB.12.0") Then
Else If ProviderIsAvailableFor("Microsoft.JET.OLEDB.4.0") Then
How to create a crystal report in vb.net 2005 using data source wizard.
View 1 RepliesI know how to read user input using textbox but it only can read character and numbers. Is it possible that I want to read user input equation?
Example:
User type A+B
User put range of A and B.
1.25<A< 3.56
2.45<B< 9.87
I failed to read the equation using textbox. Is it there are other ways that can use to read equation input A+B?I am using VS2005 and VB.Net. I really new in this programming using VB.Net.
The drive is connected via USB and the problem I'm having is that, periodically, while my code is executing, the usb drive seems to disconnect and reconnect. (Nothing to do with the program, but the drive itself).I want to find a way to prevent these temporary drive reconnects from interrupting my code. IE, i want to insure that whatever read or write that is requested is actually executed even in the case of a temporary drive interruption.
View 1 RepliesI want to develop an application which can Write, Save, Read text files(or html files) What I want the application to do is. When I open my application I can write stuffs and then it will save it to my hosting/server. Then, the application will read the text which I already save.. So far, I can only make the application read it by using WebBrowser control and navigating it to a specified URL. Example: [URL](or message.txt) Which I modified from the website not from the application. I want to modify the text or html files from my application.
View 6 RepliesI am developing a program where i will download and save an xml file from a url as abc.xml. I open the abc.xml in a datagridview with a dataset without problem.I am confused how can i read raw per raw the datagridview and assign the data in a database table? i am using vb 2008 + msde2005 express.I show the whole content of the xml file in the datagridview with the following [code]I dont know how to create a loop where i can read the datagridview line by line save data in variables (ex.strings) and save it in a databese table?
View 6 RepliesHaving a slight permission problem with Win 7 I am guessing it will be the same on Vista but work fine on XP (yet to try)But my program is sitting in: C:Program FilesCompanyProgram And its trying to create new files alongside itself in the Program Files area but bombing out which I know is permissions. If I go there to create the file myself it comes up with a UAC prompt and when I hit allow it works fine but obv the program can't do that byiteslf so bombs out.Is there anyway I can over come that without the user having to grant admin rights to the program each time it starts or do I have to write data to another place?
View 4 RepliesI;m attempting to write code to read several NMEA ports and format the data for archive. When I execute the following code:
Using Commportno As IO.Ports.SerialPort = _
My.Computer.Ports.OpenSerialPort(portName:=port)
Dim Incoming As String = Commportno.ReadLine()
way to do the following in VB 2005:
I need to access, but not display, a web page out of a VB 2005 program. The web page would be an aspx page with a query string as part of the url - with the url using values acquired thru the program - e.g. www.mysite.com?arg1=this&arg2=that
So the aspx page would produce an html output with values I need placed in specific elements. I want to read that page from my app and do stuff with the resulting values.
How to create a data forms with the data forms wizard in VB 2005
View 6 RepliesIm working on a HSD 32 bit data bus to serial converter via a microcontroller. Now first I want to make a sort of data sniffer to read the data bus (32Bit) .All on the controller side is working and the stream of bytes are coming in via RS232 as 4 bytes in HEX like FD,A5,45,8B . I already converted the bytes in Dec and ASCII to determine what is passed true the bus and how fast and stuff.. Now that is all correct and working very well if the LSB (least significant bit) of the 32 data bus is Data line 0 and the MSB (most significant bit) is Data line 31 but if that is not the case I need to invert the 32Bits (like as I would invert the connector on the bus) . How do I best do this using the 4 bytes I send from the micro controller.
Example:
(MSB) 01001000 01100101 01101100 01110000 (LSB)
HEX= 48 65 6C 70
DEC= 72,101,108,112
ASCII= H E L P
I need to invert it with a button to:
(MSB) 00001110 00110110 10100110 00010010 (LSB)
HEX= 0E 36 A6 12
DEC= 14,54,166,18
ASCII= (SO) 6 : (DC2)
Im designing a program that will read from various text files (preferably RTF files) and then put them into the RTF box in the program when a button is clicked.
Here is the portion of my code that i am referring to.
Try
Dim fileText As String = My.Computer.FileSystem.ReadAllText("c:\" & selectedHero & ".rtf")
infoDisplay.AppendText(fileText)
infoDisplay.Rtf.Format()
Catch
MsgBox("Selected Hero currently has no File with us.")
End Try
Now heres the problem. In the file i have a few pictures and its formatted and what not. I thought since its a RTF file and the Box is RTF it would auto format.... but anyways. It appears like this in the RTF Box.
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}}
{\*\generator Msftedit 5.41.15.1507;}\viewkind4\uc1\pard\f0\fs20{\object\objemb{\*\objclass Paint.Picture}\objw3000\objh3000{\*\objdata
[CODE]...
Ok so im not sure how i can read from a RTF file and put it in the RTF box with the right format....Ive been searching around for a while.
i have installed visual studio 2005 in my computer i want to create a sql server 2005 file i saw a sql server 2005 option in my installed components i want to know how to create a sql server 2005 from my visual studio 2005 it is possible or not.
View 1 RepliesHere's the content of the file that i want to read: [code] Instead of using a streamread isnt there another way to read .ini files?
View 5 Repliesi have a jpg file in which lot of text data has written . i want to extract text data from jpg file i used stream reader but when it access the data it is likewhat is it please tell me how i will read i
View 1 RepliesI would like to know if it is possible to parse .eml and .msg files in dot net (preferably from a memorystream) such that I can use them on an ASP.Net page.
View 3 Replies
