473,417 Members | 1,452 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,417 software developers and data experts.

How to export data from a form datasheet to excel via code

syedshaffee
Hey people,
I made a user interface that give's Users a filtered report in a Datasheet Format

i want to give them a feature that they could export that Result .xls format How can i do that can some one help me
Sep 10 '12 #1
1 6541
zmbd
5,501 Expert Mod 4TB
syedshaffee

Several ways to solve this problem.
Automation, docmd, etc...

I find the easiest is to do a simple transferworksheet method:
There have been several threads on this site regarding this method and the the basic link:
http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx
Please note that if you use this method and try "acSpreadsheetTypeExcel10" it will cause you a headache... that's not a defined constant... replace that with just the number 10 for 2007/2010 formatted files.

The correct answer depends on what you need for the user output.

-z
Sep 10 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Ken | last post by:
I have a form that has a command button on it to open a report. The report is based on the forms data, if it's filtered the report is filtered, if the form is showing 100 records the report is...
6
by: Elena | last post by:
I'm trying to export data to an Excel worksheet. I can export the data in the cell values perfectly. I need the code to change a header and footer for the worksheet, not for the columns. Is...
1
by: go2bee | last post by:
Tamplat is it HN: 49xxxxx Name : Cxxxx xxxxx PID : 3xxxxxxxxxxxx Address : 1xxx x xxxx , Tambonxxxx , Ampurxxxxxxx ,Provincexxxxx Postcode : 1xxxx At xxx is Data form Table Name
2
by: Chia Lee Lee | last post by:
Hi , I have no idea on how to export data to Ms Excel 2000. I have a screen which contain a check box list that allow user to select which fields to be exported to MS Excel. When user checked on...
3
by: mukeshsrivastav | last post by:
dear sir i want to move form excel to access. i have 5 excel file having same formats and fields.now i want to import all data in one access table. importing one file is easy .but importing and...
3
by: AnishAbs | last post by:
Hi , I have got a senario in which large amount of data should be copied from MS excel to MS SQL server. which is the best option to do so. Because when I use recordsets the process is very slow and...
2
by: prinsipe | last post by:
Hi guys, i'm able to export data to an excel from my asp .net page, i can even create multiple worksheets. the problem is, i can not specify where worksheet should the data be placed. below is my...
1
by: tommydnp | last post by:
Is there a possibility to insert values into excel using only an oledb connection? It's no problem for me to select all data, but when I want to insert data or create a table, there's a problem. ...
2
by: mangalamonkey | last post by:
I want to export data into an excel file using iReports.I could do that but the data is displayed as an image. I need the data to be displayed as cells as in the excel sheet. plz do reply.........
6
by: shilpag | last post by:
How to export data to multiple excel worksheets using php can anyone help on this please
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.