Access Marcos - New to this

[SC5138]

Hi

I wonder if you can help. I created some code in Excel to basically import a report, pulling out the specific columns and then adding the count and values of the columns. This was populated in specific cells on a another tab all by pressing the 'import' button.



Now as my data is now too big for excel, I need to replicate this in Access database. I am new to writing marcos in Access.
Can this be replicated?

Any help would be great.

Thanks in advance.

SC

[Micron]

The functionality can be replicated. Suggest you start by researching the TransferSpreadsheet method of the DoCmd object for Access. The name of the method is somewhat misleading as it's not restricted to transferring spreadsheet data. The count and totals part would be handled by queries, which can be presented as datasheets or displayed as a form or report. A lot of responders here don't seem to use macros very much (I almost never do), preferring vba code, but are willing to take a peek at created macros that don't seem to function properly. The macro can also be fired by clicking a button, same as you seem to be doing in Excel.

[SC5138]

Thats great, thanks.
I will look this up and I may be back with more questions.

Thank you.
SC