Käynnissä

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

Needed:

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, 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:

deepindersingh

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)
5.3

9 freelancers are bidding on average $186 for this job

illuminesoft

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)
7.4
ITservice

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)
7.6
schoudhary1553

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)
7.1
aanvikm

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)
5.9
carlosperezit

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)
5.0
arcan08

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)
3.4
thuyduongrands

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)
3.5
vmadhavan15

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)
3.2