Hi,
Am basically importing data from EXCEL into Access and below is the code.
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "DLPTemp3", FileName, True
Dim Rs1 As ADODB.Recordset
Set Rs1 = mdbx.OpenRecordset("SELECT * FROM DLPTemp3;", SeeChangesReadWrite)
DoCmd.Close acTable, "DLPTemp3"
mdbx.Execute ("DROP TABLE DLPTemp3")
However the Excel contains a field with a & (eg: test & Test) and I need to rename that to 'Test and Test' before importing into an SQL table.
Could someone pl tell how do I go about renaming in a tempdb.
Thanks