Best Practice for disconnected data?

M

morganpdx

Joined
Nov 12, 2008
Messages
2
Reaction score
0
Hi. I have a bunch of data in a SQL database that I need to use in several excel spreadsheets. The spreadsheets need to be able to function in a disconnected state. Any opinions on best practices for this situation? I currently am running VB functions to go out and run the stored procedures and populate the data, but it takes a bit longer than I'd like. I'm toying with the idea of changing the function to instead create an XML file that can be shipped along with the spreadsheets that use the data, but I haven't used XML with Excel before (using Excel 2003). Thanks for any opinions/advice!

-Morgan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate listbox with disconnected recordset? 5
Best Practice for Public Variables for Column Headings 2
A code to import other xls data into one xls file 3
Best Practice for Obtaining hWnd 11
Dynamically generating a spreadsheet with custom pivot table including data 2
Combining Data from Multiple Worksheets into 1 8
Best Practice - Transfer Data 2
Best Substitute For Excel Opinion Requested ? (Mine Is Badly Corrupted) 2

Top