SQL Server and MS Access

Main Menu

Home
Today's Posts
FAQ
Search
Contact Us

Java Network

Linux Archive
Java Tips
Java Tips Blog

Sponsored Links

Welcome to the Java Forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community, you will:

have access to post topics
communicate privately with other members (PM)
not see advertisements between posts
have the possibility to earn one of our surprises if you are an active member
access many other special features that will be introduced later.

Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

LinkBack

Thread Tools

Display Modes

#1 (permalink)

04-08-2008, 04:59 PM

Hima

Member

Join Date: Apr 2008

Posts: 1

SQL Server and MS Access

Hi everybody.

I need to generate a report. the required information is in Excel sheet.Using this sheet and four tables in the SQL Server database, results should be generated. i am running five queries in sequence to generate the report. this results in creating temporary tables. till now i did this manually by importing the Excel sheet into MS Access database and linking the SQL Server tables to it, but now it need to be automated. can anyone help me how to get the SQL Server tables and the Excel sheet into Access database programmatically using Java.i cannot crreate temporary tables in SQL Server since it is the production server.

Sponsored Links

« Java connecting to sql server 2005 | PLSQL - JAVA Integration »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads

Thread	Thread Starter	Forum	Replies	Last Post
Web-App server connection - How to hit the particular app server from the web server	maruthi_s	Enterprise JavaBeans	2	07-15-2008 08:11 PM
Access with MS SQL	cachi	Database	1	08-07-2007 09:54 AM
Help with access a database using Microsoft Access	cachi	Database	1	08-07-2007 09:51 AM
access to dll files	Heather	Advanced Java	1	07-08-2007 02:30 AM
Access a variable	Eric	New To Java	2	07-04-2007 10:29 AM

All times are GMT +3. The time now is 01:02 AM.