Sign in to follow this  
Followers 0
mdthanh

Script export data from MSSQL and MSACCESS to excel

3 posts in this topic

#1 ·  Posted (edited)

Hi,

I have completed a script to export data from MSSQL or MSACCESS to Excel

Hope it useful for someone.

Screenshot:

Posted Image

Features:

Support database: MSSQL, MSACCESS

Export speed of MSSQL: arround 15 seconds for 700,000 records with more than 30 fields.

Will support more databases on next time and allow to select existing tables/views if any.

MDT,

ExportToExcelV1.rar

Edited by mdthanh

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

@mdthanh,

Very useful.

Really impressed with the speed. Looking forward to your next post.

Regards,

Ajit

Edited by ajit

Share this post


Link to post
Share on other sites

Thanks Ajit, I am working on MySQL and support select existing tables/view of MSSQL.

Hope I can finish it soon.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Similar Content

    • gritts
      By gritts
      I am attempting to create a script which will poll a SQL database that is part of our internal server monitoring application. The results would then be pushed to the local growl client on my desktop. I am successful at querying the SQL database using the SQL UDF and can send growl notifications fine as well...

      What I run into is "Syntax error converting datetime from character string." when I try to query the database with the value from a previous query. (My appologies for making this sound confusing)

      For example, I query the database and return the results into a 2D array. I can display the results fine with "_ArrayDisplay". I then take the results from the query and using the next to last row from the results, get the value from the datetime column.


      $tmpDate = String($aData[$iRows-1][1]) MsgBox(0,"Date",$tmpDate)

      It is when I take the value in $tmpDate and attempt to search with it that I get the syntax error above.


      $iRval = _SQL_GetTable2D(-1, "select * from dbo.AllpagesToday WHERE PageRecip = 'SERVER_OC1' OR PageRecip = 'SERVER_ONCALL' AND Date > '" & $tmpDate & "' ORDER BY Date;", $aData, $iRows, $iColumns)
      I have also attempted to convert the date format from: 20120319090303 to 2012-03-19 09:03:03.000 to no avail.

      My conversion pieced together from other posts:

      Func _convertToDateTime($dtString) Local $newdt $newdt = StringRegExpReplace($dtString, "A(d{4})(d{2})(d{2})(d{2})(d{2})(d{2})(?:.*)","$1-$2-$3 $4:$5:$6") MsgBox(0,"Convert Results",$newdt) Return($newdt) EndFunc
      When I search using the converted datetime, it is as if the query ignored the datetime value and returns all values of the 2D array.

      $iRval = _SQL_GetTable2D(-1, "select * from dbo.AllpagesToday WHERE PageRecip = 'SERVER_OC1' OR PageRecip = 'SERVER_ONCALL' AND Date > '" & _convertToDateTime($tmpDate) & "' ORDER BY Date;", $aData, $iRows, $iColumns)
      Any suggestions? If more information is needed, let me know.
    • Herb191
      By Herb191
      Okay so quite a while back I thought I saw a AutoIt script that converted a MSSQL database to a MySQL database. I can’t seem to find it on the forums anywhere. Does anyone know if one exists? And if there is not an Autoit solution where I can find a good free converter. Thanks.