can someone tell me how to manipula

[R9772]

can someone tell me how to manipulate columns within tables through the use of vb?

 

[scking]

What do you want to do? We don't want to guess what you would like.
-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------

 

[R9772]

this is what i have so far. however, would like to include an if statement manipulate columns within the table i just imported. is this possible?

Option Compare Database
Function doIt()
Dim mydb As Database
Set mydb = CurrentDb()
Dim strSql As String
Dim strfile As String

strfile = "c:\myFile.xls"


End Function

 

[scking]

Please explain manipulate. Your current code snippet doesn't do anything so I can't determine your objective. -------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------

 

[R9772]

the following is the complete code:

Option Compare Database
Function doIt()
Dim mydb As Database
Set mydb = CurrentDb()
Dim strSql As String
Dim strfile As String


strfile = "C:myFile.xls"

DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, "myNewFile", "C:myFile.xls"



End Function


it imports a file from excel but i now want to manipulate the columns within the new table using vb. for instance if the sum of column a is > the sum of column b column c = a - b else nothing.