Recent content by vusi_dube

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...

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

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.

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

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.

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...