Create an MS Access file using DBI

Hello everyone,

I am trying to create an MS Access file using Perl in a Linux environment. By the way I am on a SuSE Linux envrironment. I have already installed the DBI module. I am looking for some direction on how to go about accomplishing my task. Thanks in advance,

Hanz

Jul 25 '08 #1

Subscribe Post Reply

1665

eWish

971

Expert 512MB

Welcome to Bytes.com!!!

Can you give more details. That is a very vague description. Do you have any sample code that we can look at?

--Kevin

Jul 26 '08 #2

hanz

Welcome to Bytes.com!!!

Can you give more details. That is a very vague description. Do you have any sample code that we can look at?

--Kevin

thanks Kevin!

I have not written any code for this project yet since I am still trying to gather enough info to tackle the problem. What I want to do is output the data I show in my webpage to a MS Access file at the user request, so they can download the file to their PC. I have done this with MS Excel since Perl has the package Spreadsheet::WriteExcel. My website is set up on a SuSE Linux and I have access to an Windows machine on my network if I have to install Access there.
Any help or direction you can me give is appreciated.

Jul 28 '08 #3

numberwhun

3,509

Expert Mod 2GB

thanks Kevin!

I have not written any code for this project yet since I am still trying to gather enough info to tackle the problem. What I want to do is output the data I show in my webpage to a MS Access file at the user request, so they can download the file to their PC. I have done this with MS Excel since Perl has the package Spreadsheet::WriteExcel. My website is set up on a SuSE Linux and I have access to an Windows machine on my network if I have to install Access there.
Any help or direction you can me give is appreciated.

Well, my first suggestion is that you have a look at the DBI page on CPAN. That will show you how to use the DBI module. Using that, you can issue the necessary commands to not only populate the database, but create it as well if needed.

Hope that is what you are looking for. As Kevin said, still a little vague.

Regards,

Jeff

Jul 28 '08 #4

Similar topics

Permission to Create a File in VB .Net

by: fripper | last post by:

When testing a VB .Net application on my system (with IIS installed) I get an error message when using the fileopen function and the file does not exist ... i.e. I want fileopen to create the file....

.NET Framework

how to create an Access data input form external to db?

by: intl04 | last post by:

How do I create a data input form in Access that is external to the Access database to which it's connected (if that's possible, which I believe it is)? For example, if someone clicks on an Access...

Microsoft Access / VBA

Trying to create a database in a MS Access DB via JDBC drivers

by: Albretch | last post by:

.. I am trying to create a database in a MS Access DB via JDBC drivers. I have tried both sun.jdbc.odbc.JdbcOdbcDriver and ids.sql.IDSDriver From some reason both drivers Exceptions tell me...

Microsoft Access / VBA

How do I create pdf reports from Access?

by: dog | last post by:

I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...

Microsoft Access / VBA

Can't create New Proj. with XP/.NET 2003

by: Marc Miller | last post by:

Hi all, I have 2 dev. machines, the 1st is Win 2000 with .NET 7.0 and the 2nd is XP Pro with .NET 2003. My Web Server is Win 2000 Server with IIS 5.0. I can create a new project on my test...

ASP.NET

How to create a MS Access File

by: Minh | last post by:

I search in all the Disscussion but can not found. How can I create a MS Access Database file using C# code with a given Table Structure ? For example, I want to create a Access Database File...

C# / C Sharp

Cannot create ASP.Net project in Visual Studio .Net 2003

by: JonSteng | last post by:

..Net Visual Studio Professional 2003 Version 7.1.3088 ..Net Framework 1.1 SP1 Version 1.1.4322 IIS 5.1 Windows XP Professional SP2 Micron T3000 Laptop (1.5 GHz; 1GB RAM; 40GB HD with 17GB Free)...

ASP.NET

Create DLL in Visual Studio 2005 accessible by Excel 2002

by: Steve | last post by:

I am trying to create a DLL in Visual Studio 2005-Visual Basic that contains custom functions. I believe I need to use COM interop to allow VBA code in Excel 2002 to access it. I've studied...

Visual Basic .NET

create a dynamic array of pointers with initial values of NULL

by: sandy | last post by:

I need (okay, I want) to make a dynamic array of my class 'Directory', within my class Directory (Can you already smell disaster?) Each Directory can have subdirectories so I thought to put these...

C / C++

how to create an ASPNET.mdf file?

by: Mich | last post by:

Hi, i'm building an web application for anonymous users. They can take a look in the website, nothing more. In order to perform other actions, the anonymous user must be logged. So i create an...

ASP.NET

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

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

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

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