Visual Basic :: Transferring Data In Access/VB6

Transferring Data From Access Into Excel
hello,

i'v just been given an assignment of linking a database to other microsoft applications using visual basic. I have only had two lessions on visual basic and have only got as far as clicking on a button and having the date entered. I can programe in C and C++ builder but never used visual basic and it looks quite diffrent.

What im trying to do is transfer numbers from my database into an excel worksheet. My database is a hotel system and in the billing section the amount for each department is entered. Im trying to get these numbers to be transferd into a pre-made excel template to create an invoice. The idea is the formulas are already in the excel invoice and will automatically calculate the total and vat etc.

iv tried looking at previous posts but do not understand all of the code.

Any help would be much appreciated.

Thanks alot,
Jason

Transferring Data From Access To Excel
I'm using office 97 and am tryin to get some data from access to excel. With the code I've written in excel all that is displayed in the label is the default caption. How can I display what is in varVariable? Thanks for any help.

This is my code:

Option Explicit

Sub Data()
lblDat.Caption = varVariable()
End Sub

Function varVariable() As Variant

Dim dbsNozztst As Database
Dim rstLngBinDat As Recordset
Const conChunksize As Long = 32768

'open database "db1.mdb" and recordset "dbt_Pruefbericht"
Set dbsNozztst = OpenDatabase("C:db1.mdb")
Set rstLngBinDat = dbsNozztst.OpenRecordset("dbt_Pruefbericht")

'use GetChunk method to assign long binary data to a variable
varVariable = rstLngBinDat!dbf_MessDaten.GetChunk(0, conChunksize)

'close database and recordsets
dbsNozztst.Close

End Function

Transferring Data From Excel To Access
Guys,

I've been fiddling with VB for a week or so now and am learning fast, but I've hit a wall.

I need to take the content of two ranges (on speperate excel sheeets) and send them to existing tables in an existing database. Manually I would use the "Data, Convert To MSAccess..." menu option.

Any ideas?

Kindest

Frank

Transferring Data From Access To Excel
how can i transfer the data present in an Access Database to an Excel Spreadsheet??

done thru Visual Basic that is... any idea anyone?

Comparing Dates Before Transferring Data From Access DB To Excel (ADO)
I'm guess I need to transfer the info into a buffer (recordset?), do the comparison, then only extract the relevant data to Excel? Is there a simpler way of doing this? And does anyone have links to examples?

Must the Format be identical (eg. Long Date vs Long Date, or can it be like Long Date vs Short Date) when it comes to comparing dates?

Furthermore, when i use the preset MM/DD/YYYY, whenever i enter a date like '10/12/2006' (12 Oct), it automatically reverts to '12/10/2006'... and if i enter 12/15/2006' (15 Dec), it doesn't seem to recognise the date at all! (btw, i'm using British settings for win xp)

Thanks in advance... need all the help i can get.

Creating New Word Document And Transferring Data Fields From Access
Hi

I'm trying to find a way to start up a New Word document whilst in Access, where it will transfer particular data fields to the new word document....can this be done, if so, can anyone please help?!!

Many thanks

Matt Davis

Transferring Data From VB Form To VB Data Report
Could anybody please help me.

I have two text boxes and a command button in a form.
On clicking the command button, I would like to see the values in these text boxes to be displayed on a VB Data Report form in the Report Header section.

I badly need to do know how to do this.

Transferring Data
I have an array that stores the order rows of data should appear if they were sorted. What I need to do is find the row number stored in first spot in the array, locate that row in the worksheet, and copy it into the first row of a new worksheet, and so on until I reach the end of the array. My code looks like this:

rowOrder = array of ranks of rows if they were sorted
ReDim DataArray(UBound(rowOrder), 19)

For i = 1 to UBound(rowOrder)
For j = 1 to 19 'Number of columns in each array
DataArray(i, j) = Cells(rowOrder(i), j)
Next j
Next i

Sheets("Sheets2").Select
For i = 1 to UBound(rowOrder)
For j = 1 to 19
Cells(i, j) = DataArray(i, j)
Next j
Next i

Basically I'm just making a copy of a worksheet and sorting it based on data in one column. The thing is all this copying into a two dimensional array and out of a two dimensional array takes a long time. Is there any way to do it faster?

Transferring Data Using DDE
Quote:

Originally Posted by Jasch

Quote:Originally Posted by jimw630Unfortunately the program that is receiving the transfer only uses DDE.

Jim

Reboot is right. . . . DDE sucks! What do you have so far? Do you know about using the TextBox for DDE? LinkTopic, LinkItem, etc. properties?

I used DDE back in the timeframe that Reboot referenced. I've pretty much blocked that from my mind at this point. I really don't know anything but what the help has to say about it, except maybe how SLOW it is. . . . ;-)

Jasch

What was DDE replaced with and how can i find information out about other programs?

Transferring Data Using DDE
A newbie to VB needs help. I need the ability to view an Excel spreadsheet in VB without opening the Excel program itself. Then by clicking a button, move the value of a specific cell to another application using DDE. I have searched for several days for the command structure to do this but have been unsuccessful. Any help would be appreciated.

Thanks,

Jim

Transferring Data From DB To DB
I am trying to write code that will restore archive data from one DB to another DB. I'd like to do it without the use of TransferDatabase.

Thanks,
Phil

V.B. TRANSFERRING DATA
in visual basic 6, how do i transfer data from a text box into a list/combo box, so that the user can select one of the options saved, and then type in futher info so that this can be added to the same random access file which has other data link to the option.

Transferring Data From PC To PDA
Hi

I am working on a database program and would ideally like to be able to automatically transfer data to a PDA in another format, e.g. CSV...

I'm a bit of a Newbie to be honest, I have set up the database side of things and can save a .CSV file on my PC using the open "c:file.csv" as output method.

My PDA appears as My Mobile Device in My Computer, is there a way of pointing the save of the CSV file to this PDA instead of my PC?

Many thanks in advance

LJE

Transferring Data Over A VPN
The beauty of using a VPN Connection is that the exact program can function over
a) A Network Connection on the end of a cable
b) A Network Connection using the Internet using a Dialup Connection
c) A Network Connection using the Internet using a Broadband Connection
d) A Network Connection using a Wireless Device (eg, GPRS Phone)

My problem id that while b) (Dialup Connection) goes through the processes of working, the results are not always consistent, causing a loss of data at the other end at times. ie, NOT VERY RELIABLE - THEREFORE USELESS

Basically, all I want to do is send a Table from one Access Database to a computer at the other end, and create the latest version of this table in the receiving computer.

This is the code I am using (which works brilliantly when connecting via a cable, and has worked with some success using broadband)

Set DatabaseIn = OpenDatabase(ReadFromDataPath)
Set DatabaseOut = OpenDatabase(WriteToDataPath)

' DeleteTable
StrSql = "Delete * from MyTable"
ADOcmd.CommandText = StrSql 'On DbOut
ADOcmd.Execute

DatabaseOut.Execute " INSERT INTO MyTable SELECT * FROM [" & ReadFromDataPath & "].MyTable"

The problem is that the table sometimes doesn't quite get there (having waited an hour or so on dialup)

Has anyone got any ideas on dealing with this common requirement ?

eg, Should I use FTP ? Should I transfer the file first, check that it arrives, and then delete the old one and replace with the new one ?

These are the sorts of options I am contemplating - perhaps your experience can point me in the best direction -

With Thanks

Transferring Data
I have an application that must allow 2 users over the internet/LAN to transfer data back/forth directly. How do you do this?

David

TRANSFERRING DATA
Does anyone know where I can find a lotus notes odbc driver. I am trying to transfer some data from a lotus notes db into an oracle db with vb, but I don't know where to locate the driver for lotus notes. I would greatly appreciate any information.

Thanks

Transferring Excel To Access
Hello all
I have to populate an access db with data from a spreadsheet (as is, no specific columns etc) with VB6. I'm playing with DoCmd.TransferSpreadsheet, but are there better ways, and how do I get it working? I'm stuck with runtime error 2495, 'action or method requires a Table Name argument'.

This is my statement:
DoCmd.TransferSpreadsheet acImport, _
acSpreadsheetTypeExcel97, _
"table1", _
"c:my documents able1.xls", _
False

Help or new directions would be apreciated!

Transferring Data In Excel
I want to put some code behind a button that when pressed will copy the rows that i have highlighted and transfer them into a new worksheet.can anyone help?

Transferring Data Between Worksheets
I have the following code to transfer data from one worksheet to another and then print the worksheet:

Sub PrintSheets()
Dim lRow As Long, i As Long

With Sheets("data")
lRow = .Range("A65535").End(xlUp).Row

For i = 3 To lRow
Sheets("stmt").Range("C5").Value = .Range("A" & i).Value
Sheets("stmt").Range("F10").Value = .Range("B" & i).Value
Sheets("stmt").PrintOut
Next
End With
End Sub

I would like the data in range B to transfer as 0.00 if the cell is blank.

Is there a simple way to accomplish this?

Thanks for any suggestions.

Transferring Certain Data To Another Sheet
The first table show the raw data. I need to extract some datas to another sheet which is shown on the second table. I will input the date and then thru the code, it will only extract the data (those highlighted in yellow which is on that date) into those designated cells. The raw data will keep changing and expanding so i need a vba code to generate this, need your help on this, thanks!

Transferring Data To Excel
I am writing a program which transfers data from the serial port to an Excel file.

At the moment, values are read into a label every 5 seconds. Each new value overwrites the previous one so there is only one value in the label at a time.
Below is the code which does this.

Code:
Private Sub Timer1_Timer()
' Read in and display values.
Dim in_byte As String
Dim in_message As String
in_message = ""
MSComm1.InputLen = 1 ' Read a single byte from buffer each time.
MSComm1.Output = "READ?" & Chr(13) & Chr(10) ' Query instrument.
Do
Do
DoEvents ' Continue processing events.
Loop Until MSComm1.InBufferCount >= 1 ' Wait for a character.
in_byte = MSComm1.Input
in_message = in_message & in_byte ' Append to i/p string.
Loop Until (in_byte = Chr(10)) ' Wait for a LF terminator.
Label2.Caption = in_message ' Display message.
End Sub

I now need to send these values to an Excel file starting at cell B3. The times must start at cell A3, the first time being 0 and incrementing in steps of five.
The reason that they must start here is that later i will be inserting headings in the range A1 to B2 with a VB macro.

I already have a program which creates a two dimensional array using a random number generator and sends it to an Excel file.
The following code does this.

Code:
Private Sub Form_Load()
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oWS As Excel.Worksheet
Dim oRng As Excel.Range

' Start Excel and get Application object.
Set oXL = CreateObject("Excel.Application")

' Get a new workbook.
Set oWB = oXL.Workbooks.Add
Set oWS = oWB.ActiveSheet

' Initialize the random number generator.
Randomize

' Create an array with 100 rows and 2 columns.
Dim DataArray(1 To 100, 1 To 2) As Variant
Dim r As Integer
For r = 1 To 100
DataArray(r, 1) = r - 1
DataArray(r, 2) = Rnd() * 1000
Next

' Transfer the array to the worksheet starting at cell A3.
Range("A3").Resize(100, 2).Value = DataArray

'Save the Workbook and Quit Excel
oWB.SaveAs "C:Book1.xls"
oXL.Quit

What i need to do is replace the random number generator with the values from the serial port and there corresponding times.

The program must be fully automated and be able to cater for an unknown number of values.

Can anyone help?

Transferring Data From Vb To Crytals
hi can anyone give me a link or a tutorial on transferring data from vb to crytals thanks....

Transferring Data From One Database To Another
I have an Access 2000 database that has different table names and field names compared with another Access 2000 database.
I need to transfer data from this one database to the other but the tables and fields are different.

Is it possible to export data from one database to another if the tables are different and the fields are different?

Also how do I export the data from this one database to another??

Transferring Data From 2 Tables. HELP!!!!
guys, i'm new here, almost as new as in programming.

my problem is this,

I created a database software using VB6 (DAO - i know, i know, but its all i know right now) We decided to add the data on two separate desktops and now i want to be able to get the data from the MS-Access table from one databse to the other.

How can i do this programmatically? Because if i open the tables with MS-Access 2000, my VB6 program will not be able to open it again?

Am planning to transfer the data through floppy. Where should i put this code?

Insert into church.mdb values (select * from church.mdb);

thanks very much for any input.

cheers!

Transferring Data From One Table To Another
hi,

here's the situation:
i have a microsoft access database called: test_transaction. this database contains two other tables: temp and rental_track. temp is used to hold temporary data and when the user verifies it, transfers it into the table rental_track. now i'm using an execute statement as such:

test_transaction.Database.Execute "INSERT INTO rental_track(Date, Time, cust_id, cust_name, isbn, title) SELECT * from temp;"

however, what i get is an error, type definition if i'm not mistaken. what exactly is the problem? do i need to declare the data source of the database during Form_Load()? if so, how do i go about doing that? however if i declare it as such:

test_transaction.databasename = App.Path & " est_transaction.mdb"

i need to declare another recordsource right?
what do i need to do to enable transfer of data from one table to another using sql statement? if anyone knows can you give me a short line of code that a newbie understand? thanx for the help people!

newbie

Transferring Data From One .mdb Database To Another
I keep getting a run-time error '424', object required error for the following.

If rst.Fields("VAN") = Null And srt.Fields("VAN") Is Not Null Then MsgBox "Transferring Van #": rst.Fields("VAN") = srt.Fields("VAN")

Basically rst and srt are both ADODB recordsets tied to different access databases. They both have similar fields to convert the data from and all have the same data types.

My situation is that on one database if a Van number has been entered in srt - I do not want it erased by the Van number in rst. I'ved tried also:

If rst.Fields("VAN") = Null and srt.Fields("VAN") <> "" Then MsgBox "Transferring Van#": rst.Fields("VAN") = srt.Fields("VAN")

But it still will not transfer the data.

Please help.

Thanks

Sincerely,

Stephen

Transferring Data From One List Box To Another
Hi

I am struggling to write a piece of code that will transfer all of the data that is in one list box into another list box.

Does anyone have any solutions for visual basic 6.

Thanks

Transferring Data Between Forms
Hello all,

Pretty basic question for you. If anyone could fully describe this to me i'd be gratefull!

How do you transfer data between forms in the same project? I cannot work out for the life of me how to do this.

Thanks,

-Comacchio

Transferring Data From A Last Box To A Label.
Ok I'm using VB6 at the mo, I've tried searching here but can't seem to find what I'm looking for. I'm kinda new to all this so sorry if this is a really stupid question.

I'm doing this task in college where I have to make a certain number from a list of 100 numbers (from 1000 to 8000) appear in a label accourding to it's index (which is being typed into a text box.

My teacher has no idea what to do and nor do I nor some guy in my class so does anyone know what I should do?

Thanks in advance!!

Transferring Data From One Program To Another
I'm a student and finals happen to be coming up. I'm trying to make a quiz program to study with. I would assume I'd need to make two programs, one to make the questions, and one to ask them. I'm not completely sure on how to transfer the questions from one program to the other though, any thoughts?

( No, I refuse to study by just looking over my notes. )

Thanks,
Jabal

Transferring Data From Excel To VB
Ok..so I was thinking of making an application with VB that can take data from certain Excel spreadsheet cells(not many, just a few cells) and populate them into a VB application that I will create and they would appear in their proper fields..I'm having problems of conceptualizing how to go about this.I tried to think of ways to do this, but none make sense.If anyone out there can help me on how to possibly go about doing this(if it is in fact possible), it would be most appreciated. Thank you!

ps. What I want to do is lets say take the value in cell A4 and that value should appear in a specified text box in my application with a push of a command button that send it from excel to the app.

Transferring Data Using An IPX Protocol
Is there a control that will allow me to transfer text over a network using an IPX protocol.

I doubt there is so are there any other suggestions on how to do this.

Thanks Cameron

Transferring Data Between Apps
How would I transfer text from a textbox in one application to another textbox in a different application?

This one has really got me stuck.

Transferring Data Conditionally In VBA--Can It Be Done?
HI,

I am working on a spec for my team and their request at the time seemed somewhat simple--until I got to this part! The idea is that there are three spreads in this workbook: Credit, Investment and a report Shadow. (The report shadow will be used to compare their own data with Regional data to make sure nothing is missing.) Ideally they will fill out the Credit spread and when a loan books (or date closes) and they insert the closing date, the third spread will be activated and filter in certain information such as ClientName, DateClosed, etc. So this "shadow report" should be populated ONLY if the booking date (that one column) is posted with no duplicates. Right now I have it set up to be run by a macro. Not ideal, but it works, but it only grabs the first line and I worry about duplicate information.

Is this even possible with VBA? And if this is beyond the scope of VBA, what language does this?

Thanks for any advice!!

Sarah

P.S. I have attached my file in case it helps to see what I am "trying" to program.

Transferring Data Between Two Databses
Hi Folks

I am writing a Visual Basic .NET app the has two elements, a base app and a mobile app.  From time to time, the mobile unit will need to copy data up to a master database.

My plan is to have two separate ODBC connections, but have them share a dataset.  The Mobile unit will fill a datatable in the dataset using a standard "SELECT * FROM TABLE" type statement from DB1.  Then I would like to use some sort of a statement like "INSERT INTO TABLE (SELECT * FROM DATASET/DATATABLE)" into DB2.

For information purposes, DB1 is an Oracle Lite installation, DB2 is a standard Oracle 9i Server installation.  For the tables that need to share data the schema is the same.

My problem is I don't know exactly how to phrase the second SQL statement to get the data from a datatable instead of a actual table or view.  I remember reading some time back that it was possible in Visual Studio 2005 to set up a dataset to behave like a virtual data table accessible by SQL commands but I can't find any reference now.  Can someone tell me what the proper phrasing is to do this?  Or is there a better way to do this that I may not be aware of?

Thanks for any help you can provide.
CraigHartz

Problem In Data Transferring
Hi all,

I'm doing one project in VB with MS Access.

I want to know whether it is possible to transfer the datas in the excel to MS Access and Vice Versa. If so, pls give me sample or example coding or any reference url havinf those.

For example: In MS Access, I'm having the following fields:

Field Type
------ ------------
Ticket_no Number
Date Date
Area Text
Sub-Area Text
Priority Text

In the excel sheet also I'm having this, I want to transfer the all the datas to MS Access Database thru' VB Codings and also if some of the rows from excel is not transferred to MS Access(due to Data type mismatch) that to be placed in different excel.

For example, In the Excel Sheet if i'm having

Ticket_no Date Area Sub-Area Priority
----------- -------- -------- ---------- --------------
878798 03/12/2005 ACC Staff High
213456 12/04/2005 FIN Staff Low
123321 30/04/2005 ACC Staff High
Staff 02/02/2005 ACC Manager Medium
129093 022/02/2005 DEP Bud Low

In the above excel data, 4th(ticket_no is wrong) and 5th(date is wrong) is wrong, so these two should not placed in MS Access. Though, Access won't allow, we need to get what are the rows not transferred to Access.

Shortly, I need the checking the datas in excel before entering into the MS Access.

pls, anybody if have sample or example coding or any coding url, it will be useful for me.

Thanks in advance,

Regards,
Ahmed

Transferring Data Via VBA In Excel--Can It Be Done?
HI,

I am working on a spec for my team and their request at the time seemed somewhat simple--until I got to this part! The idea is that there are three spreads in this workbook: Credit, Investment and a report Shadow. (The report shadow will be used to compare their own data with Regional data to make sure nothing is missing.) Ideally they will fill out the Credit spread and when a loan books (or date closes) and they insert the closing date, the third spread will be activated and filter in certain information such as ClientName, DateClosed, etc. So this "shadow report" should be populated ONLY if the booking date (that one column) is posted with no duplicates. Right now I have it set up to be run by a macro. Not ideal, but it works, but it only grabs the first line and I worry about duplicate information.

Is this even possible with VBA? And if this is beyond the scope of VBA, what language does this?

Thanks for any advice!!

Sarah

P.S. I have attached my file in case it helps to see what I am "trying" to program.

Transferring Tables From Access To Web Server
Could anyone please help me with this ???

I am creating an application to transfer data from users's PC's via a default internet connection (using FTP) to a web server.
Here is the scenario, Each user has a Access2000 DB on there PC's (72 users) each DB contains a table called stock. The master DB on the web server needs to contain 72 tables called user1stock, user2stock, user3stock, etc so that each user doesnt overwrite the stock file in the master DB. I want my application to automatically, when run from each user export and rename the table and then the bit I cannot work out is how do I get the renamed tables into my master DB on the server ??

Can anyone please help ?????

Regards

Transferring Image Between Access Field And VB
Hi

I'm having problem linking an image in an access database to my form. The image is a company logo which I need to be able to update if the company logo changes at any time. When the form loads up I get this message....

"Unable to bind to field or Datamember: 'Logo' "

What type of field should the Logo image be in the access database? OLE object? And should I use the 'Image' control on the VB form or something else?

Is there restrictions on what file types I can use for this logo so that it can be transferred between VB and access?

Also.
Using the Common Dialog Control im allowing the user to select a new image if desired. How do I then associate this picture to the database field (i know how to display the image inside the image control on the form already).

This is what i have in the Form_unload procedure

Private Sub Form_Unload(Cancel As Integer)
Data1.Recordset.Update "Logo", imgLogo.Picture
Data1.Recordset.Update "CompanyName",
txtCompanyName.Text
Data1.Recordset.Update "SupportPhone",
txtSupportPhone.Text
Data1.Recordset.Update "SupportPerson",
txtSupportPerson.Text
Data1.Recordset.Update "SupportCompany",
txtSupportCompany.Text
Data1.Recordset.Update "BackColor", txtBackColour.Text
Data1.Recordset.Update "FontColor", txtForeColour.Text
End Sub

I'm sure i've asked enough quesitons for one day.

Thanx for ANY help you can offer.

Clint

Transferring Date From Access To Excel
I'm using office 97 and am tryin to get some data from access to excel. With the code I've written in excel all that is displayed in the label is the default caption. How can I display what is in varVariable? Thanks for any help.

This is my code:

Option Explicit

Sub Data()
lblDat.Caption = varVariable()
End Sub

Function varVariable() As Variant

Dim dbsNozztst As Database
Dim rstLngBinDat As Recordset
Const conChunksize As Long = 32768

'open database "db1.mdb" and recordset "dbt_Pruefbericht"
Set dbsNozztst = OpenDatabase("C:db1.mdb")
Set rstLngBinDat = dbsNozztst.OpenRecordset("dbt_Pruefbericht")

'use GetChunk method to assign long binary data to a variable
varVariable = rstLngBinDat!dbf_MessDaten.GetChunk(0, conChunksize)

'close database and recordsets
dbsNozztst.Close

End Function

Transferring Data Between Excel Worksheets
I am creating a mini system where a user can highlight a number of cells and then on the click of a button the data in these cells is transferred to designated cells in another worksheet. Any ideas on how to code this?

Thanx

Transferring Data From Excel To Word
I have given up on trying to transfer data straight from Excel to Word. So, what I will do is attempt to write the data to a text file (from Excel), go to Word and extract the data from the Textfile and insert it into my Document using bookmarks.

So here are my questions:
1. How do I transfer my data from an Excel file to a textfile.
2. How do I transfer the data from the text file into Word.

I am trying to do this on my own in the meantime and if I manage to do it I will post it for the benefit of other forum members.

Transferring Data From Excel Into VB6 Combobox
I am locating a sheet inside of Excel(I've got this), but when I try to take the data from this sheet, I am getting an error. (Object doesn't support this property or method) I have referenced the Excel Library, but can't quite seem to figure this one out. I would really appreciate the help.

objExcel.Range("A9").Select (Works)
objExcel.Range(objExcel.Selection, objExcel.Selection.End(xlDown)).Select (Works)
Set Item = objExcel.ActiveCell.Selection (This is where my error is)

For Each Item In Selection
Item.Activate
If IsEmpty(Item) Then
GoTo Again
End If
cboPcMark.AddItem Item
Again:
Next Item
End If

Transferring Data Between Tables With A Query
My thinking does not match that of the designers Access. I am trying the use a query to modify some data and append the modified data to an existing table. The source table has forty some field. The destination table has seven fields.

I keep getting the “INSERT INTO statement contains the following field name: ‘Owner`”. Make sure you have typed the name correctly, and try the operation again.”

Do the two tables have to have the exact same fields to move data? What am I over looking?

Transferring Text Box Data To A List Box
I have a multilined text box, and i want to submit the data to a list box.

problem is when i try to submit it using

VB Code:
List1.AddItem (Text1.Text)

i get all of the data in the first entry of the list box... i watn each line to be submitted as a seperate list box entry.

how do i do this?

Transferring Data From 1 Excel Spreadsheet To Another
Can anybody out there please give me some advice in regards to transferring data from one spreadsheet to another?

much obilged

Transferring Data (Half Resolved)
I've got an app that interacts with an .mdb and is distributed to several remote locations that all have their own records in the db. What I'm looking to do is add a function to the app that will gather some of the data (customer names and addy's as an example) and put it in to some sort of container, which will then be emailed into the main office. At that point, the info would be viewed, by location as well as overall, at the main office.

I was thinking about having the location app store the data in either an excel spreadsheet or xml doc for email distibution, with either a main .xls or another app to take the data and make sense of it at the main office.

I was wondering what would be the most efficient (file size being the main concern) way to go about something like this?

Also, I was wondering what a good way to go about releasing updates to an app is. The remote locations have been using it long enough that I don't want to overwrite the entire prog directory and loose the data in the mdb, just update the actual exe and corresponding files. I'm using Inno for deployment--Any thoughts on this one?

Thanks--

Guph