Questions

I want to download a set of data into excel, about 50,000 records, which can only be downloaded using SQL. What cloud based, or other service could I use? I need bi-monthly updates and need the data converted to Excel.

Excel can import CSV files, and most databases can dump data as CSV. You could potentially use something like Sequel Pro locally to do this.

Honestly, without knowing the WHY behind the need, it's tough to say what the right solution is.

Really, manually syncing an Excel document back and forth with a database seems like a complex and fragile solution to a problem. Is it possible you could remove the Excel sheet from the equation? Or use Google Sheets to make it available collaboratively online?

Depending on the problem you're trying to solve, there's probably a much easier solution that a SQL import/export.

I'd be happy to go over solutions and help you find a simpler way to solve this problem if you'd like. Just tag me for a quick call.

Good luck!


Answered 9 years ago

Unlock Startups Unlimited

Access 20,000+ Startup Experts, 650+ masterclass videos, 1,000+ in-depth guides, and all the software tools you need to launch and grow quickly.

Already a member? Sign in

Copyright © 2024 Startups.com LLC. All rights reserved.