Dump records into excel

Aug 28, 2014 at 1:18 PM
Do you have any demo where data is dumped straight into an excel table? I'm having trouble getting my head around this part and can only drag it over a cell at a time (really slow).

Thanks,
Aug 28, 2014 at 11:07 PM
Hi,

You might have a look at this project: http://www.gatekeeperforexcel.com/other-freebies.html

Note that it doesn't use the latest SQLite for Excel module, but otherwise it might be a good start.

-Govert
Sep 3, 2014 at 6:52 PM
I looked at that, but it would still require all used to have the addon. Your solution works much better for what I need, but i'm having problems in figuring out how to pull the data back in an array as opposed to cell by cell.
Sep 3, 2014 at 9:47 PM
What is your specific problem - working with Variant arrays and setting Range.Value?

For general Excel and VBA stuff StackOverflow is quite helpful: http://stackoverflow.com/

-Govert