I have been facing a problem since last two days, actually i want to import some data from a file (file can be csv, txt, sql, xls etc) and after some filtration, export it into csv file. Basically i want to know whether a tool which provides an environment to import different types of file or data where we can perform filtration of data with the help of sql query and then data could be save into file(file can be csv, txt, sql, xls etc).
View 2 RepliesI am developing an application in which data will be handled offline and then fed back into the main application. Hence need the facility of Export & Import of data.I am using WriteXML to export desired data from the server database using dataset.
The data is imported back, into the Client module. During the day client may modify/insert records in the imported data. At the end of day, the client exports back the modified data and which needs to be imported back into the system's main database.Now what I want is, if new record is entered by the client then it should be inserted into the dataSet and if original record is modified during offline mode then the Original data should be updated with the new value. I think, its similar to the DataSet and Database concept i.e when dataSet is updated. But am not able to do this.
At present, if I import then all data is imported irrespective of whether the data already exist or not.And if I implement Primary Key in the dataset then for modified data it gets stuck with constraint.
On one of my form i have two buttons export and import.
[Code]...
and when other user click on import it will copy same data in the fields.So please help me which way and file will be the best to use. and if possible what will be the code.as i am new to developing so please explain in the basic manner
give detail steps of importing only data from one database to other in SQL 2008
View 3 RepliesI have created an application that can store employees details, that part is not a problem and frankly is sorted, I have used a sql database to save my data, all information is displayed in TextBox controls on my main form.
The part I am struggling with is creating 2 buttons.
The first button I want to be able to import data from an excel file into my data set
The second button I want to create is a back-up button, which exports all the data from my dataset into an excel file
I have several DataGridView controls populated with data. I want the ability to export all the data from these populated controls to 1 XML file. In effect the controls are populated after my project runs. The user will be given the option to export the data.
I then in turn want the ability to import this same data back to these empty controls at a later point in time. I would run my project in a different mode which would display the empty controls. The user would be given the ability to uploaded the XML file and repopulate the controls.
I have a project am about to start and I want to used vb.net 2008.
I have an access database with some messed up data for example instead of firstname, Lastname field the person who create the database used fullname for the name filed. The good thing about this is the clerk types the names with a space.
I want to create a program that find the first name insert it into a new table.firstname and last name and put it into a table.lname using a loop all at once.
I'd like to make a program module that exports all records from three tables in a database into a file at once(I means not adding row by row, maybe like BULK). how to code for exporting and importing?
View 7 RepliesI am developing an app that will import numeric data and export it to various text files using ascii templates. I am basically converting the template file into a single string, replacing application fields in the string with {0}, {1}, etc... and adding the result into an array that is then passed to the String.Format(str_Template, Params()) to provide the final output. I have set it up so the template will use the standard VB.Net formatting syntax.
A simple template example:
{<prt_Mark>:G} {<prt_Qty>:F2} {<prt_Length>:F2} {<prt_Remarks>:G}
[code].....
it's possible (and easy) to work with microsoft formated documents like 'xls' and 'doc'. i'd like to do same task but using open formats, in my case: 'ods' and 'odt'.
View 2 RepliesI was wondering if there any standard format to import/export brushes in .net. For example importing a Photoshop brush to a WPF application brush.
View 1 RepliesMicrosoft Windows XP Pro, SP3
Microsoft Visual Studio 2008 SP1
.Net 3.0 3.5
I am trying to find out a way I can save all my application data that is saved in my.settings to a text file so that later on it can be impoted and used on another computer later on.
I created a program that keeps track of Items but I need to export the data that is saved in the My.settings I have over 200 difrent entrys that have data stord in it alot of numbers etc. how can I do this.
Goals.
1).. Have two buttons on form Import Data Export Data
2).. Each button must prompt (dialog) the user to find the file if there importing the data and if there saving the data Name the file (Name File Dialog)
Basically my program uses the my.settings to store the data I know this data is then put in to the windows registry in some form or another I need to have a way to back up and restore all this data at anytime and restore at anytime 24/7 but it has to be in a file and the user needs to name it and a dialog needs to be shown etc etc etc...
how can i put an import /export csv on my programe? i use vb8
View 5 Replieshow can i put an import export in csv format on my programe i want to send data from my programe to excel
View 4 Repliesi m trying to prepare a small application for exporting or importing registry key(whole branch) using xml filesi found example on code project but not working and also i found a component source commercial tool which worked perfect
View 9 Repliesi m trying to prepare a small application for exporting or importing registry key(whole branch) using xml files i found example on code project but not working and also i found a component source commercial tool which worked perfect my question is how can we access all 8 types of data values from registry specially multiword value?
View 2 RepliesI would like to save let's say "HKLM/SOFTWARE" into file using API. First I open the key using RegOpenKeyEx. This works fine as I see that the ReturnPointer is different from zero and differs also when I switch from "SOFTWARE" to other subkey, therefore I assume no problem there.The problem comes when I want to save into the file. It creates only a blank file with return code of 1314. I have googled for this, but only found that this error means that application has no privilege to perform the action and I need to setup "SeRestorePrivilege" & "SeBackupPrivilege" property somehow. I haven't been able to find a good VB.NET example for this and as I am very weak with APIs I wasn't able to construct one of my own, therefore I would like to ask you for advice on this.Could you please help me on how to set the privileges so that I can export/import registry? [code]
View 4 RepliesI need to be able Import and Export data from my database in the app im developing. I have been having trouble finding the proper way to do this. I have to assume some of the people using this wont have Office installed so this process has to be able to work on its own.
Im using Visual Basic Express with SQL server 2008. Using LINQ to SQL with a local database.
I wanna make a program that will create a batch file and convert it to exe. Problem is that at the batch code there's a line that needs the program wget.exe in the same directory to work. Is it possible to bind wget.exe into the final exe (The bat converted to exe), and when it's ran to export wget.exe in the same directory?
View 2 Replieshas anyone come up with a with a way to save a treeview without using a BLOB, I have some items that are 8-10 levels deep on it. if I could export it to xml and back again that would be ok, I need to store its info in a databse cell set to memo. but I need to inport the text from the cell and insert it back into the treeview, then when I save i need to save the data back into that cell.
You Know Your Addicted To Computers When - Your main computer is a 7 terabyte, Core2Quad 3 Ghz +, with 4 or more gigs ram, over 200 programs installed, and you would rather sit with it programming than go to the movies!
Oh No, I've got 13 PC's in the House and 7 are in my bedroom and my main one exceeds this set of stats.
Is there any way to import / export IE cookies programmatically ?
View 1 RepliesSo im making a program that need to save from time to time i turn on the computer. i have maded a text file called save.txt in the file there are something like this
a 0
b 0
c 0
[code].....
I want to make an Export / Import function in my application .. I found some code online that should be able to do this.
[Code]...
I'm fairly new to programming and have little to no experience with sql and file transfers. Here's what I'm trying to do:
1. Link my program to a database containing images (or pathnames to images)
2. Allow user to select a starting image and ending image (max 50) based on image numbers (which they already know)
3. Collect selected images from DB or could just be a copy of the image.
4. Export images to a new folder so that my other program can process and OCR them
I have the form built, but I just can't figure this out.
I'm trying to learn RSA encrypting/decrypting in vb.net and Im having some problems.Its important that I can export / import the RSA cert.
VB
Imports System.Security.Cryptography
Public Class Form1
[code].....
I got one problem. I did simple listview-saver, (with 1 line) and all working (import, export)...
But i want to add new colums. But I don't know how to export or inport them.
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
TextBox4.Text = TextBox1.Text & vbNewLine & TextBox2.Text & vbNewLine & TextBox3.Text & vbNewLine
Dim str(3) As String
Dim itm As ListViewItem
[Code]...
This code is with adding items to colums, but it saving only first item from line. Anybody know how to export and import all items from line?
I have to import a tab delimited file into Excel and export it back out to correct a formatting issue caused by FoxPro. I need to pad a column with 10, Zeros and that is good with this here: objxl.columns("B:B").numberformat="0000000000". However I have 2 cells in the sheet, row 1B and 2B that I want to exclude from the number format above. Because it is a date field and it writes to that same column so it pads my date. I do have a need to Pad that date field with mmddyyyy so I have to pad it 8 - zeros.
View 5 RepliesIm trying to add an export import method in visual basic. Export from Access database to Excel Worksheet or .csv. And Import From Excel worksheet or .csv to Access database
View 3 RepliesI have Access application and I want to import and export Outlook contacts in this access DB, programmatically. How do i do it?
I have founf Linked tables does the same automatically. But then if the appliaction runs on the other system then will that linked table work?As the linked tables is synchronised for my outlook. Is there any way to make this generalised, so that linked table concept can be used?
I'm creating a small application that will export the record from database to excel format (.xls) and import the record from excel as well. i have this code below i dont if this the right approach but im getting the error. Im using emulator btw. error :"The process can not access the file 'My Documents est1.xls' because it is being used by another process." Code: I'm still figuring out about import function any ideas?
View 2 Replies