Search results
-
G
Excel code in VBA
Hi, I have written following VBA code in excel which i need to write in access. Sub Macro3() i = 2 Do While (Cells(i, 1) <> "") If (Cells(i, 1) = "CONU_TEMP.xls" And Cells(i + 1, 1) = "CONU_EIM.xls") Then Range("b" & i).Select Range(Selection, Selection.End(xlToRight)).Select...- gundecharahul
- Thread
- Replies: 4
- Forum: Modules & VBA
-
G
Import data in text datatype
Hi, I have a csv file which i need to import into MS-Access as a table. I am doing this by using transfertext method. Now the problem is that i want all the data in CSV to be transfered as text data type in MS-Access table. I know we can create /update the specification file in import/export...- gundecharahul
- Thread
- Replies: 2
- Forum: Modules & VBA