Previously i uploaded information into my database as xls via vba code in access e.g:
DoCmd.TransferS preadsheet acImport, acSpreadsheetTy peExcel97, "tbl_MinWag e", "R:\HR\Mini mum Wage\Exports from ADP\NMW CH " & Text33, True.
By using this method i would be able to save a excel spreadsheet in a folder and add a date on the end of the document e.g. NMW CH 081007.xls
Then in my access form i would have a text box i.e. Text33 and just add ion the date e.g. 081007 and click a button. The vba code would then select the correct file e.g. NMW CH 081007.xls
I an now trying the same thing in txt format but it does not work. I get an error. e.g.
DoCmd.TransferT ext acImportDelim, "tbl_01_BKUK_Ac tive&Withdrawn_ Import Specification", "tbl_01_BKUK_Ac tive&Withdrawn" , "R:\HR\HR_Syste m_Reports_Folde r\ADP_Downloads \HC_RSCUK" & Text33, True.
Does anyone know why or how I can get around this?
DoCmd.TransferS preadsheet acImport, acSpreadsheetTy peExcel97, "tbl_MinWag e", "R:\HR\Mini mum Wage\Exports from ADP\NMW CH " & Text33, True.
By using this method i would be able to save a excel spreadsheet in a folder and add a date on the end of the document e.g. NMW CH 081007.xls
Then in my access form i would have a text box i.e. Text33 and just add ion the date e.g. 081007 and click a button. The vba code would then select the correct file e.g. NMW CH 081007.xls
I an now trying the same thing in txt format but it does not work. I get an error. e.g.
DoCmd.TransferT ext acImportDelim, "tbl_01_BKUK_Ac tive&Withdrawn_ Import Specification", "tbl_01_BKUK_Ac tive&Withdrawn" , "R:\HR\HR_Syste m_Reports_Folde r\ADP_Downloads \HC_RSCUK" & Text33, True.
Does anyone know why or how I can get around this?
Comment