Search results

  1. V

    Import Spreadsheet with multiple tabs into Access

    Dave, I've created the tables with the exact field names etc But i have two problems 1. The field names have spaces(Thou shalt name thine fields with no spaces etc) and I'd like them to map to the excel ones as part of the code that loops and brings through the data. I have added "_" in my...
  2. V

    Import Spreadsheet with multiple tabs into Access

    Hey David, Yes they will be, consistent headers tab names etc. The only thing that changes is the spreadsheet names. Thanks
  3. V

    Import Spreadsheet with multiple tabs into Access

    As it says on the tin. Need some help getting these into Access from an excel spreadsheet (located on sharepoint). I'm using the spreadsheet fields to create the table fields in Access. Thanks in advance.
  4. V

    Get External Data - Excel Spreadsheet

    Sorry, meant to be the same please use as examples.
  5. V

    Question Use Excel formula in Access

    In access where you would reference a cell in Excel, In Access you must reference the Field you'd like to do the calculation on into the field you'd like your results to appear. I hope this helps.
  6. V

    Get External Data - Excel Spreadsheet

    Hey All, I'm new to the forum apologies if any etiquette has not been adhered. I'm in the process of importing an excel spread sheet from an external source (SharePoint). I have the link for the file and have edited it from the Https:// to \\projectspace. intranet.sharpoint etc etc\. The...
Back
Top Bottom