Export Multiple Files From IDEA into Excel

aveenm293

Forums

Hi There
I am looking for a custom function / script that will allow me to export multiple IDEA databases into excel without exporting each one individually. I am using IDEA 8.5.
Thank you in advance!
Aveen
 

Brian Element Sun, 05/26/2013 - 11:02

Hi Aveen, would that be multiple idea databases into the same Excel spreadsheet but with different worksheets or each IDEA database gets a separate spreadsheet?  IDEA has two scripts that might help you out which I have attached.  Let me know if you are looking for something different.

Files
170_1.gif (3.6 KB)

aclark Mon, 04/13/2015 - 11:38

Brian, thank you for the script to export multiple databases into one Excel worksheet. It is exactly what I was looking for. What is the max amount of databases that can be exported into one worksheet? I tried to export about 20 and the script began processing before showing an error.
Thanks,

Brian Element Mon, 04/13/2015 - 12:51

Hi Andrew,

These are actually scripts developed by IDEA, I just posted them here as they are very useful.

Can you give me more info on what the error was, also where these large databases?  You might have exceeded the limitations of excel.  Let me know a bit more info and I will see if I can figure out what happened.

Thanks

Brian

Derek Sat, 09/30/2017 - 05:49

Hi Brian,
Based on your script -  Export Multiple Databases.iss, if I try to export multiple database (for example , one is sales personal information, anothers are sales order、invoice 、material training ... etc ) become a MS Access file, have any possible export to one Access file not multiple Access files ?
Thank you in advance!
Derek

Brian Element Mon, 10/02/2017 - 07:40

Hi Derek,

I tried to find a way to do this on the weekend and I couldn't find an easy way.  Excel doesn't allow you to save as an Access database and in Access you can only bring in one Excel worksheet at a time.  So unfortunately I can't help you out with this problem.

Brian

raoul.kelly Thu, 08/15/2019 - 12:48

Hi Brian 
Im hoping you can help me ,  Im having an issue with both  Export Multiple Databases.iss   and exportdatabase.iss  . When I run the export , i'm presented with the the browser for folder option, but am unable actually "browse"  . Attached below is a screenshot of what I see
 
Thanks in advance for your advice
 

svanzon Mon, 07/20/2020 - 08:39

I have the same problem, it always opens only the desktop and I can not browse to the IDEA folder. Have tried the script on this page and the one from the IDEAscirpt vault (the outcome is the same).

  • OS: Windows 10
  • IDEA: Client Version: 10.4.1.1032 (X86)
  • Latest Excel (Microsoft 365)

raoul.kelly Thu, 08/15/2019 - 16:12

Resolved by using Export Multiple Databases.iss   and exportdatabase.iss from IdeaScriptVault