Excel to Database - can you help?

• C# Gnu

  SSCertifiable

  Points: 5973

  More actions

  May 17, 2012 at 5:27 am

  #255997

  Hello,

  I am developing a new utility 'Excel to Database' providing easy batch data upload/insert from Excel to any database Table or Stored procedure.

  I could do with some help testing as development progresses, as I don't have access to many real life databases.

  The tool allows you enter/paste data into Excel and upload to a Stored Procedure or direct to a table.

  Also I have not tested with MySQL, Progress, DB2 etc and it would be great if anyone could help with these.

  Software is not yet complete - but connection/object interogation should be working ok.

  There is an accompanying file 'SQL-Flavours.XL-DB.xml' that contains information relating to each database type.

  I have created a beta download 🙂 ..

  http://leansoftware.net/Forum/%5B/url%5D

  Appreciate any help.

  C# Gnu
  ____________________________________________________

  
  Excel Database Tasks : efficient business data processing
  Version 3.3 released February 2015

• C# Gnu

  SSCertifiable

  Points: 5973

  More actions

  May 17, 2012 at 11:46 am

  #1489269

  By the way the Admin password is 'lean'.

  Thanks for any help

  Regards

  C# Gnu
  ____________________________________________________

  
  Excel Database Tasks : efficient business data processing
  Version 3.3 released February 2015

• C# Gnu

  SSCertifiable

  Points: 5973

  More actions

  May 18, 2012 at 1:56 am

  #1489506

  Hi

  added a getting started guide for anyone interested in helping out with testing..

  >> Getting Started Guide <<

  Many thanks for any help and suggestions.

  C#

  C# Gnu
  ____________________________________________________

  
  Excel Database Tasks : efficient business data processing
  Version 3.3 released February 2015

• C# Gnu

  SSCertifiable

  Points: 5973

  More actions

  May 20, 2012 at 5:36 am

  #1490180

  Ok! one massive code burn later :

  There is now a new enhanced version of Excel to Database now available in the downloads section...

  http://leansoftware.net/Forum/default.aspx?g=topics&f=4

  This new version :

  1/ captures any error and gives you the option to email the details direct.

  2/ auto generates SQL Insert statements when selecting table method.

  The auto generation of stored procedure command is next on the list..

  Looking forward to hearing of any test results / or suggestions ..:-)

  C#

  C# Gnu
  ____________________________________________________

  
  Excel Database Tasks : efficient business data processing
  Version 3.3 released February 2015

• C# Gnu

  SSCertifiable

  Points: 5973

  More actions

  May 22, 2012 at 1:08 am

  #1490867

  Hi there,

  New version available for review ..

  Latest release now automatically generates stored procedure statements..

  http://leansoftware.net/Forum/default.aspx?g=topics&f=4

  New features are emerging too - such as 'Extract to Excel'.

  Development is now 90% complete.

  

  Would love to hear any comments..

  Regards

  C# Gnu
  ____________________________________________________

  
  Excel Database Tasks : efficient business data processing
  Version 3.3 released February 2015