Search results

Bump to see if anyone can help me... Thanks Tim

Hi Minty, Thanks for your input. I've copied and pasted your updated code and changed YourTableName to the table name but it's generated a syntax error at the DoCmd.RunSQL sSql line. Any thoughts? As I say, I really don't understand VBA (yet!) and have bodged the code together by copying and...

Hi Ranman, Thanks for the quick response. I've added the code as below but am getting an error with the SSQL statement: Function Import_Excel() Dim myfile Dim mypath mypath = "C:\Users\timog\Dropbox\Minster Food Brokers\Brand Page Details\1.Reports\Detailed Reports\" myfile = Dir(mypath &...

Hi all, I'm new to the form and very new (yesterday!) to VBA. I have a number of spreadsheets, all formatted the same which I need to import into a single table in Access. Not quite sure how I managed it but I have a module that's now part of a query that does the job I want. However I...

Thanks Paul, appreciate your help. Tim

Hi Paul, Thanks for the welcome and the response. I've searched and think i've found some code that might work for me BUT I've never used Modules or VB before and haven't a clue where to start, any pointers to a user friendly tutorial you'd recommend? Many thanks Tim

Hi All, I've joined the forum for some help with a specific problem (for the moment!) and wondered if anyone could point me at the best thread to add it to? I'm a beginner with access (2016), can write queries from tables at best but use it to manipulate large pieces of data. Specifically I...