Visual Basic :: Transferring Excel To Access

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?

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

Error In Transferring From Excel To Access Database
I have created a DSN for an Excel file and am transferring the data to an access database through VB. One of the coulmns in the Excel file contains numeric as well as alphanumeric entries.
The numeric data is being transferred but the aplhanumeric data is not being read. A Null value is returned for all such data.
All the cells in the Excel file are formatted as "General".
Please give me a solution for this error. It is urgent please.

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.

Need Help With Transferring Excel To VB!
Hello!

Let me first start off by saying that I have just started using Visual Basic, so I'm pretty much a novice, so hopefully my question doesn't sound too stupid..

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!

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 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 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 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 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 From Excel To Standalone Projects
Hi.

I've only just made the transfer from Visual Script (which has proved useful over the years with Telnet,) to Visual Basic 6, and I have a some questions. Actually I only have two, and I've forgotten one of them, so after that preamble, here goes:

Most of my work so far has been written under Excel (because I have access to that at work, but VB is my copy and so at home only,) and although they import to VB well enough all the forms are called "Designer Forms" and I am unable to modify them with such things as File/Edit bars & minimise/maximise buttons.

Any help please?

Thanks.

Transferring Variables From Word To Excel
I am a self-taught VB6 “newbie”. I developed a Word template that uses forms for our marketing people to write purchase and sales contracts. On the forms, the user enters data, selects from drop-down lists, and checks boxes. The template then selects the proper contract language and creates the contract.

I would like to transfer the data that has been entered by the user to a spreadsheet that would maintain the basic information for all of our contracts. Can anyone guide me through how to use VB6 to append a set of variables from a Word VB6 program to an Excel spreadsheet?

I don’t know if it helps, but I have figured out how to assign the data I want to transfer to document variables. All I need to do from there is figure out how to append the set of document variables as a new row in a spreadsheet.

MUCH thanks in advance!

Vba Excel -sorting Then Transferring Then Looping!
Hey guys.
Im comfortable enough with VB but know nothing about VBA.Im trying to write a macro in Excel that does the following.

*First I want to sort column E descending.
*I then want to transfer the values E1 to a new sheet into column (E1 into)A1
*I then want to move on to column F, sort descending again, then I want to transfer the value of F1 to a new sheet into column (F1 into)A2
*And so on and so forth

below is very rough pseudocode.to be honest Im looking for direction with syntax/the best functions to use above all else.any help would be greatly appreciated.

Code:
Range1 = E:L 'this will be variable in the future done through input box or something
For Each column in Range

column.sort

for i= 1 to 8
Sheets("Sheet1").Select
MyValue = Range("E").Offset(0, i).Value
Sheets("Sheet2").Select
Range("A").Offset(i, 0).Value = MyValue
next
Next

thanks.

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 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 From Word To Excel
How to read the data from msword file one by one........and transfer it to excel. I can transfer the data to excel but the problem I am facing is reading the msword file.......if anyone can redirect me to some older messeges similar to this or give me a code will be quite helpful to me..........
Tx in advance

Transferring A Column Heading From VB To Excel
I have picked up a nearly complete application which has been written in VB6. It will export data from Access database tables to a variety of different applications, one of which is Excel. I need to carry over the name of the fields to create the column headings in Excel - I am sure this can be done I just don't know how.

Any help would be gratefully received.

Transferring Data From One Sheet To Another In EXCEL
Hi,

I am having trouble transferring data from one EXCEL sheet to another, but without using the copy function. I need to put the copied data into a relative cell reference, rather than absolute cell reference.

Currently, the code which won't work is:

Code:Worksheets("Sheet3").ActiveCell.Value = Worksheets("Sheet4").ActiveCell.Value

I think you can only have one ActiveCell in a Workbook, so therefore, how do I transfer the data from the ActiveCell to the other Worksheet using a relative cell reference.

I'd be stoked with any assistance.

Xav6

Transferring Data In Access/VB6
I am writing an app that processes fitness event results (running races, etc) and I have a 'raw' access database with a single table that collects data from my timer. I want to transfer that data periodically to another access database, or another table within the same access database, to make changes and still preserve the data in the original table. I need to do this in vb6 code. I am ok writing and reading the data. I just need some advice on the best way to get data from the original to the 'edit' table/db to make my changes.

Any suggestions?

Transferring Data From Excel To Visual Basic
I have some data in excel sheet and I want to use that data in visual basic..How can I make visaul basic to read that data in excel? And after reading data, how can I input result to a specific cell in that excel sheet?

Thanx for help!!

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

Automatically Transferring Outlook Info Into Access
I would like to transfer an Outlook 2000 Event Calendar information into an Access 2000 database. Please advise if and how I can do this where after something is entered in the Event Calendar it will also show up in an Access 2000 database. I was hoping this can be done automatically. Or if that cant be done, then run something once every 10 mins to update the Access database with the any new Outlook information?

Please advise.

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

Problems With Transferring "char" Data From SQL To Excel
Hi, I've got the following problem:

I try to transfer "char" data from SQL to Excel through DAO, then I use CopyFromRecordset to insert data into Excel sheet.

The "char" data is displayed on the sheet incorrectly (special symbols etc.)

The data in VBA debugger are correct.

If I change the SQL data type from "char" to "varchar" all was correct.

What's the problem about that "char" type.

Thank you.

P.S. I use Excel 2003 & SQL 2000.

Transferring VB Project From Access Database To SQL Server Database
Hello,

I have been working on a project at my employer to bring a current program that is run by a third-party company, in-house so that we can run it ourselves instead of paying out monthly fees to the third-party company.

The basics of the program are fairly simple. However, after getting the code about 90-95% done, I am realizing that my Access database will quickly become too small to use. I know we have SQL Server on at least one of our servers, and am thinking about trying to use that instead of Access.

My question is, how hard would it be to transfer my project to a SQL Server database instead of an Access database? I am using ADO to connect to my Access database right now. Would I have to make any adjustments to my VB code? I realize some of the SQL in the code will need to be adjusted, but what about my cn. and rs. lines of code (connections and recordsets)?

Shame on me for not realizing Access's size limitations before now. Any information that anyone can provide is greatly appreciated. Thank you in advance.

Transferring An Exe
Hello everyone! I am trying to transfer a BINARY EXE from a Win32 machine to a Win16 machine running Windows 3.x.

The transfer has to take place through the serial ports on both machines. The machines are connected using a null-modem cable.

I would like to know what code would I use that will work in VB6, on the sending Win32 machine, and in VB3, on the receiving Win16 machine.

I am familiar with working with the MSCOMM control, in VB3 and VB6, to transfer strings, but not files.

I Am Exporting An Access Query To Excel, How Can I Define The Excel Cell Size/format
I am using TransferSpreadsheet to Export a Query to Excel with a button from Access.

How can I define in Excel when I export it, the size of the cells, the type of letter (Arial, Bold), The Background color.

Private Sub Impacto_Click()
DoCmd.TransferSpreadsheet transfertype:=acExport, _
spreadsheettype:=acSpreadsheetTypeExcel9, _
TableName:="Impact", _
Filename:="C:Impact.xls", _
hasfieldnames:=True
End Sub

Exporting An Access Table To A New Excel SS And Open Excel File Afetr Export
Hi,

Can some help me with writing the code to Export a table from Acces into a new excel spreadsheet, then open an instance of excel to view the newly exported table? I can get the file to export but I am having trouble with the code to open Excel, thanks for you help. See code below..

Private Sub Command26_Click()

DoCmd.TransferSpreadsheet transfertype:=acExport, _
        tablename:="newreqtable", _
        FileName:="F:UserdataSelectionData.xls", hasfieldnames:=True, _
        Spreadsheettype:=8

MsgBox "Export is Complete", vbOKOnly, "Selection Data Export"

MsgBox "Your new file is located on F:UserdataSelectionData.xls", vbOKOnly, "Data Export Location"

'This is where I need to have excel open the file for the client.

End Sub

Closing Excel Process After Creating Excel.Application From Access 2003
After such code:
Code:
Dim xLs As Excel.Application
Set xLs = New Excel.Application
xLs.Visible = True
xLs.Workbooks.Open DtR
‘do stuff
xLs.ActiveWorkbook.Close savechanges:=False
Set xLs = Nothing
There is always Excel process left running. When I do this 5 times I will have 5 instances of Excel running.
Is there a way to kill this process at the end of the code?

How To Import Excel Data From A Closed Excel File To Access Table?
Hi friends,
i have the following Excel sheet

A B
1 BILL PAID
2 CM20 650.00
3 CM32 1750.12

I want to import the same data into an Access table with the same field name.

Any help?

Thankx and regards

Haris

_____________________________________________________________________

Edited by - harisraz on 6/18/2006 1:33:00 AM

File Transferring
Ok i have made a chat program where u can chat and send files...
you are able to send 1 file but u go to send the second and then it comes up with a error in the code i will paste the code can someone help me work it out????????

Code:
Private Sub Winsock_DataArrival(ByVal bytesTotal As Long)
'goes through the recieved data and finds the code and finds the Message and then sends it to everyone'
Dim i As Integer, data As String, code As String, hfile As Long, lngChunksize As Long, strData As String
Winsock.GetData data
For i = 1 To Len(data)
code = Mid(data, i, 1)
If code = " " Then
code = Left$(data, i - 1)
data = Right$(data, Len(data) - i)
Exit For
End If
Next i

Select Case LCase(code)
Case "/msg"
logChat data
Case "/bfile"
m_blnTransferring = True
m_strFilename = data
LogFileTrans "Recieveing File: " & data
txtFileName.Text = data
Winsock.SendData "/nfile "
Case "/nfile"
hfile = FreeFile
Open fileN For Binary As #hfile
If (lngFilePos = 0) Then lngFilePos = 1
Seek hfile, lngFilePos
lngChunksize = LOF(hfile) + 1 - lngFilePos
If (lngChunksize > CHUNK_SIZE) Then lngChunksize = CHUNK_SIZE
If (lngChunksize = 0) Then
LogFileTrans "File Sent!!!"
blnTransferring = False
data = "/efile EOF"
Winsock.SendData data
DoEvents
fileN = ""
ingFilePos = 0
Else
strData = ""
strData = String$(lngChunksize, 2)
Get #hfile, , strData
lngFilePos = lngFilePos + lngChunksize
Winsock.SendData "/recvfile " & strData
DoEvents
End If

Close #hfile
Case "/recvfile"
hfile = FreeFile
Open App.Path & txtFileName.Text For Binary As #hfile
Seek #hfile, LOF(hfile) + 1
Put #hfile, , data
Close #hfile
Winsock.SendData "/nfile NEXT"
DoEvents
LogFileTrans "Chunk Recieved, Requesting Next Chunk!"
Case "/efile"
m_blnTransferring = False
LogFileTrans "File Recieved!"
txtFileName.Text = ""
End Select
End Sub

Transferring Value Across Public Sub
In this code
Call Convert(text1(0).text,text1(1).text)

Public Sub Convert(c1$,c2$)

C2$=ltrim$(str$(val(c1$)*10))

exit sub

the text1(1).text doesn't change value

If I did
x1$=text1(0).text
Call Convert(x1$,x2$)
text1(1).text=x2$

it works.

Is there any way to get out of using the intermediate variable?

thanks

Transferring Info
Hey there

I have recently created a spreadsheet which contains 3 sheets.

Sheet 1 holds most of my information, and by using the Data|Filter|Advancefilter option, i am selecting one entire column of information and copying it onto sheet 2.

The problem is, although i am transferring the entire coulmn of information onto Sheet 2, i need to leave 5 rows blank, therfore, i am needing to separate the transferred information.
I am using the formula $A$1:$A$20 to copy the information into Cells A1 to A20.
However, i need to leave cells A8 - A12 blank, so is there any way that i can copy the selected info over, but leaving these cells blank.

Would something like $A$1:$A$7:$A$13:$A$26 work?

Thanks for the help

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 Values
Hi again,

I am trying to create a vb program that will ping a given address...
This i can do.

But what i need is to be able to transfer the values for eg. time (ms)
packets sent/recieved that the command screen gives you back and display them in to my vb prog.

does any know how to do this..?

Thanks very much.

Osk.

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

Transferring Database With VB
OK, I made a basic login screen and and menu for a program, i added the database along with it, and I think i just found out why, but I make it able to register etc, i made a zip and put the database file, and the exe to my program, but when my friend said it dont work. any ideas or help

»Zero.

Ftp Not Transferring. *notresolved*
I am currently using this code i found while searching to upload a file to FTP:

VB Code:
Private Sub Command1_Click()ITC.Protocol = icFTPITC.URL = "zone.ee"ITC.UserName = "******"ITC.Password = "******"ITC.Execute , "PUT", "C:1.txt", "C:1.txt"While ITC.StillExecutingDoEventsWendITC.Execute , "CLOSE"MsgBox "Transfer Complete"End Sub

It Tells me Transfel Complete but when i go to the ftp i cant find that file.

Transferring Row Of Listview To Another/
Is it even possible without having to go one by one? Just hoping, alot easier code that way

Transferring In MailBox
I recently installed Exchange Server 2003 on our server. We used to have a macro that dispatches the email on the user's personal folder.

Is it possible to take these file (email.msg) and transfer it in the user's exchange mailbox so he could have his old email in his Outlook inbox ?

Transferring Records
In my program I have two tables in a Access database. Both tables have exactly the same fields and properties. One table is to store records temporarily until the user is satisfied and then I am to tranfers all the records from the temp table to the regular table. Is there a quick way of doing this without opening a recordset for both tables and just transfering the records one by one?

I am using ADO to connect to the database.