Translating data from MS Access to MS Excel

Please tell me how can I get the data from MS Access using perl script and that data I need to export into excel automatically using perl. Please post some sample code.
Thanks In Advance!

Jul 25 '07 #1

Subscribe Post Reply

1541

miller

1,089

Expert 1GB

You have posted your question under Perl Articles instead of the Perl Forum.
I have moved it across for you.

- MODERATOR

Jul 25 '07 #2

numberwhun

3,509

Expert Mod 2GB

Please tell me how can I get the data from MS Access using perl script and that data I need to export into excel automatically using perl.

Well, to start with, to access the Access database, you will probably want to use the DBI module. You can find information on this either at this website or at CPAN. To access and write to an Excel file, you will possibly want to use the Win32::Ole module from CPAN. Those should get you started.

Please post some sample code.

Since this is forum and not a code writing service, why don't you write the code and we will help you as you go(where we can).

Regards,

Jeff

Jul 25 '07 #3

Similar topics

Translating XML

by: Philipp Lenssen | last post by:

Is there any way to import/ export XML into Word or Excel? See I want to have XML files translated. Now some translators would say "We don't do that", so we wrote a nice Web interface to do it....

.NET Framework

exporting data from ms-access to excel worksheet using ASP.

by: sridevi | last post by:

Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...

.NET Framework

Export Data to Excel for Report Printing

by: Steven Stewart | last post by:

I have a user who has been using Excel for a while to keep statistics and print reports. She finds using it cumbersome because of long formulas and a lot of copying and pasting. I have designed...

Microsoft Access / VBA

VBA code help Export Excel data to Access table

by: Mads Petersen | last post by:

I'm stuck in this code. Hope you can and will help me. I launch it from excel. I have made the following code work, but not as i whant. I need the ranges to be working with something like xlDown....

Microsoft Access / VBA

Controlling Excel from Access: Using Sendkeys to enter data into an Excel Input Box

by: Jack | last post by:

Windows 2K Pro Access/Excel 2003 Hi there, I have a large number of password protected Excel Workbooks. The files are protected by code that runs when the workbook opens. The code asks the...

Microsoft Access / VBA

How to insert bulk data into an existing data base?

by: Hi5 | last post by:

Hi, I am new to access I usedto work in Oracle and Mysql. I am after a way that enables me to populate a database I designed in access with lots of data which can be sorted in excel sheets, ...

Microsoft Access / VBA

255 Character Limit for Linked Excel data

by: Grip | last post by:

Hi, I have gone throught the group and Microsoft's online help and have seen many suggestions but I am still seeking clarity: 1. I have an excel spreadsheet. Column A contains text that may...

Microsoft Access / VBA

Exporting Access Data to Update Excel Spreadsheet Daily

by: semijoyful | last post by:

OS: Win XP SP2 Access version: 2003 Excel version: 2003 I am new at this, as I am sure you have gathered from this post title:) I am working on a form where users can input data in Access and...

Microsoft Access / VBA

save a flat export data file as an excel file

by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:

Hi all, I have a question for you. I have a .csv file which has many lines of data. Each line has many data fields which are delimited by ",". Now I need to extract part of data from this...

ASP / Active Server Pages

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

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

C / C++

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General