Results 1 to 6 of 6
  1. #1
    Yama12 is offline Member
    Join Date
    Sep 2011
    Posts
    4
    Rep Power
    0

    Default export access database to excel file

    hi
    first i connect to an access file as database then i get some query like this sql code and save it to a new table:
    Java Code:
    SELECT * FROM TABLE INTO SMS
    now in want to save the result in an excel file instead of SMS table....
    but how??

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,920
    Rep Power
    19

    Default Re: export access database to excel file

    Comma separated file?
    After all, you have given us no info at all about the format for your excel file.

  3. #3
    Yama12 is offline Member
    Join Date
    Sep 2011
    Posts
    4
    Rep Power
    0

    Default Re: export access database to excel file

    in past in ms-access file ,i right clicked on the table and used export as Excel file
    in this way i have a excel file exactly same as my access file
    i want

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,920
    Rep Power
    19

    Default Re: export access database to excel file

    Is it an Excel file or a CSV?

    If it's a CSV then write a CSV as a file (possibly using the Apache CSV library).

    If it's an Excel file then you'll need to read up on something like Apache POI.

  5. #5
    Yama12 is offline Member
    Join Date
    Sep 2011
    Posts
    4
    Rep Power
    0

    Default Re: export access database to excel file

    its excel
    read up on something like apachi???!!!! i dont know what are u exactly talking about!!!
    i have found this sql syntax in somewhere

    SELECT * INTO [Excel 8.0;Database= c:\\1.xls].[sheet1]

  6. #6
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,920
    Rep Power
    19

    Default Re: export access database to excel file

    That's Access SQL, so you'd want an Access forum to find out about that.

    Apache POI.

    Or, possibly, Open CSV, which might be easier.

Similar Threads

  1. Upload excel data to access database
    By ravikumar.achi in forum New To Java
    Replies: 20
    Last Post: 01-19-2012, 11:30 AM
  2. Replies: 4
    Last Post: 02-01-2010, 11:13 AM
  3. upload excel file into database
    By bhasker4 in forum Introductions
    Replies: 1
    Last Post: 07-13-2009, 09:13 PM
  4. how to fetch 20,000 records from excel sheet & insert into access database using Java
    By santosh_tamse in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 02-22-2009, 10:24 AM
  5. Replies: 3
    Last Post: 08-05-2008, 03:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •