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

Taidot: ASP, Excel, Microsoft Access, Visual Basic

Näytä lisää: tool convert access sql, free convert access sql, convert access sql web front end, asp, microsoft excel, 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

Tietoa työnantajasta:
( 5 arvostelua ) Farmington, United States

Projektin tunnus: #15247843

Myönnetty käyttäjälle:


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 Lisää

$100 USD 10 päivässä
(22 Arvostelua)

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

$155 USD 3 päivässä
(261 arvostelua)

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 Lisää

$222 USD 1 päivässä
(200 arvostelua)

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 Lisää

$150 USD 3 päivässä
(195 arvostelua)

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 Lisää

$277 USD 3 päivässä
(34 arvostelua)

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

$222 USD 3 päivässä
(33 arvostelua)

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 2 päivässä
(26 arvostelua)

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 Lisää

$160 USD 3 päivässä
(7 arvostelua)

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 1 päivässä
(4 arvostelua)