next »

[TechnicalTalk]

 TechnicalTalk » Programming and Web Development » Classic ASP 3.0
 Export record to Excel Sheet

[universal]

universal  

 Export record to Excel Sheet

Hey All,

I have query.

Can we export the recordset values to some Excel Sheet.

I have some users data, collected in ADO Recordset Object and I want to export it to Excel Sheet.

Can we perform this action in ASP?

Help needed!

Thanks in Advance 

[jaincool]

jaincool  

 Re: Export record to Excel Sheet

Hey man that is really easily job...........
Its all Graphical based and there isnt much............
You Could just use MS Acess where there is a direct option for doing such tasks.....

[Leohimanshu]

Leohimanshu  

 Re: Export record to Excel Sheet

Hi, Yes we can transfer the Data from recordset to Excell. it depends on the version of excell you are automating.you can create an array from the recordset and then populate a range with the contents of that array.

Please go through the below link for details

http://support.microsoft.com/kb/246335

Let me know if this help you

[singam]

singam  

 Re: Export record to Excel Sheet

You might need several attempts
- Copy the CSV file, in case you messed it up
- Open the CSV file in NotePad (Open NotePad, drag the file to it. )
- Do "Save As", now what is the suggested format of the file?
- I recommend importing the file in Excel instead of open it
- In both cases, use the same format used in Notepad

I faced issues like that when I work with Arabic/Hebrew chars, and these steps usually work it out

If not, then pay attention to the format when you export the data from the database, most database applications give you the ability to choose the format when export
===============
Proofreading | SEO Copywriting

[sd3189541]

sd3189541  

 Re: Export record to Excel Sheet

Why do you want to export it on excel sheet?

[mak14317]

mak14317  

 Re: Export record to Excel Sheet

you can use import facility of excelsheet . .  u can easily export data or record to excel. . . . . . . . . . .

[dianna]

dianna  

 Re: Export record to Excel Sheet

f your goal is to store some or all data in one or more Excel worksheets in Access, you should import the contents of the worksheet into a new or existing Access database. When you import data, Access creates a copy of the data in a new or existing table, without altering the source Excel file.

Here are some common scenarios where you might want to import Excel data into Access:

    You are a long-time user of Excel, and you are now thinking of moving to Access. You might start by importing your Excel worksheets into one or more new Access databases.
    You are a manager who receives reports in Excel format from your employees. You want to merge the reports with an existing database to update the contents of the database.
    You are a manager, and your employees send you weekly reports as Excel files. You want to automate the import operation, to save time.
    You are developing an application where you need to write code to import Excel data into Access.

[netshet]

netshet  

 Re: Export record to Excel Sheet

have a form that allows me to filter data for the user. I would like to be able to export that filtered data to Excel. I found a solution on here by vbaInet, but I don't think I'm writing the code correctly. Here is what I have:

strSQL = "SELECT * From [KSA_by_Media Query] WHERE ([ID]=" & Me![ID] & ");"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, strSQL, pad & "Test.xls", True

Most likely the problem is that I have hardly any idea what any of that means, and I'm just copying. I've tried KSA_by_Media, which is a table rather than a query. I have also tried changing ID to the key field in my table. I also am unsure if these two lines are supposed to be combined as they are. Basically, I'm clueless, but I would appreciate any help.

Thanks

[harrymartin]

harrymartin  

 Re: Export record to Excel Sheet

I agree with netshet and he suggested a nice way