Search results

  1. S

    Importing files into Access

    Thanks Everyone for your help! Thanks for pointed to where to look I have it working now! The code I finally used and works is : Private Sub Import_Weekly_Data_Click() On Error GoTo Err_Import_Weekly_Data_Click Dim dlg As FileDialog Set dlg =...
  2. S

    Importing files into Access

    Thank you this looks very promissing, I have used the code : Dim strFilter As String Dim strInputFileName as string strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.XLS)", "*.XLS") strInputFileName = ahtCommonFileOpenSave( _ Filter:=strFilter, OpenFile:=True, _...
  3. S

    Importing files into Access

    Hi, I have been writing a Database system which requires the uploading of Excell Spreadsheets. At this time you need to put the Spreadsheets into a set directory and give them a set name for the process to work. I ma trying to make a front end that can be used by non-Access users and am...
Back
Top Bottom