In Progress

Convert Access (or SQL) record Set to Excel in Classic Active Server Pages


Subroutine writen in Active Server Pages (Classic) that copies a dataset from Access (or SQL) to an Excel File.

Sub TransferToExcel(rs, OperationType, ExcelFileName, ExcelTabName)

rs = INPUT (a open record set (either in Access or SQL) that contains the records

to export to Excel

OperationType = INPUT ‘N’ for new file or ‘A’ to append to the existing file. File name is given As ExcelFileName

ExcelFileName = INPUT (a fully qualified Excel File Name – with an extension of .XLS or .XLSX). If the file name already exists, and OperationType=’N’, it is deleted first (without prompt). If the file does not exist, it is automatically created (even if OperationTYpe=A)

ExcelTabName = INPUT (resulting tab that the record set information is exported to. If the ExcelTabName already exists in the ExcelFileName, it is deleted first

The input record set has a variable number of columns. The field name should be used as row 1 of the Excel file as the column headers.

The routine must be able to run on a Windows 2003 Server with Access AND on a Windows 2012 Server with SQL. Connection String must be saved in Application("ExcelConnectionString")

TIMING - Need asap

Skills: ASP, Excel, Microsoft Access, Visual Basic

See more: tool convert access sql, free convert access sql, convert access sql web front end, convert access sql server express, vbscript sql record set, convert access sql server 2008 free, convert access sql vba, time estimate convert access sql, convert access sql server freeware, convert access sql server 2008, convert access sql 2008, convert access sql server using bids, access sql data set, convert access sql, convert access sql server

About the Employer:
( 5 reviews ) Farmington, United States

Project ID: #15247843

Awarded to:


Hello, I have 10+ years of web development experience in ASP.NET MVC, ASP.NET Web forms(C#), Classic ASP, SQL Server, HTML5, CSS, jQuery, javascript, JSON and XML.I have handled similar projects. Please review my pr More

$100 USD in 10 days
(22 Reviews)

9 freelancers are bidding on average $186 for this job


You want to convert Access/SQL data to Excel using classic ASP code Relevant Skills and Experience ASP, Visual Basic, Microsoft Excel, Windows Web hosting Proposed Milestones $155 USD - Software Development Charges More

$155 USD in 3 days
(261 Reviews)

Will create a classic ASP file which will allow to export the table data to Excel file. Relevant Skills and Experience I have 15+ years of experience. Developed various projects in ASP with MsAccess/MsSql database whi More

$222 USD in 1 day
(200 Reviews)

Hello Sir, Please give me chance to work on your project. i am the expert freelancer here and delivered almost 270 projects with 100% client satisfaction. Relevant Skills and Experience I have more than 5 ye More

$150 USD in 3 days
(195 Reviews)

Hello Sir, I am an expert with classic asp and Excel/VBA and interested in this project. Could you please open chat to discuss the project? Thanks Aanvik Relevant Skills and Experience Classic ASP, .Net Proposed Mil More

$277 USD in 3 days
(34 Reviews)

Hi Im an expert in .net and sql I have been working in software development for the last 20 years Regards Carlos

$222 USD in 3 days
(33 Reviews)

Hi, it will be done ASAP. Relevant Skills and Experience Would like to help you as I have many years of VB/ASP programming experience. Stay tuned, I'm still working on this proposal.

$166 USD in 2 days
(26 Reviews)

I have over 10 years of experience and knowledge of accounting and good skill data entry, good at Office software and Xero, Myob, Quickbooks software all so. Relevant Skills and Experience $160 for3days working Propo More

$160 USD in 3 days
(7 Reviews)

I would like to take this one and do my best. Could you please provide more details on the same and if you are happy with my bid. Please ping me

$222 USD in 1 day
(4 Reviews)