Thread: How to convert access file to excel file????

  1. #1
    Registered User
    Join Date
    Sep 2001
    Posts
    1

    Question How to convert access file to excel file????

    Hallo???
    Is it possible to do it/??
    Can anybody tell me how by using c-programming...
    Thank you

  2. #2
    &TH of undefined behavior Fordy's Avatar
    Join Date
    Aug 2001
    Posts
    5,793
    Yeah I suppose its possible but its a lot of work.

    Its much easier to use VBA in access itself to do this. Office automation is quite easy - just look up what you want on the MSDN.

    Hell I'm sure you can save a table or query as a spreadsheet with simple macros.

    [Edit] Yeah just looked it up - theres a macro called "Output to". Just set this to output to a spreadsheet, set the path where you want it saved, Choose the table/query and your away!!!![/Edit]
    Last edited by Fordy; 09-03-2001 at 11:29 AM.

  3. #3
    train spotter
    Join Date
    Aug 2001
    Location
    near a computer
    Posts
    3,868
    Try creating a CSV (comma deliniated volume). These can be opened easily in Excel.

    All you have to do is to seperate the cells with commas. In other words write a text file spaced with commas.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Newbie homework help
    By fossage in forum C Programming
    Replies: 3
    Last Post: 04-30-2009, 04:27 PM
  2. Inventory records
    By jsbeckton in forum C Programming
    Replies: 23
    Last Post: 06-28-2007, 04:14 AM
  3. help with text input
    By Alphawaves in forum C Programming
    Replies: 8
    Last Post: 04-08-2007, 04:54 PM
  4. File I/O convert
    By Unregistered in forum C++ Programming
    Replies: 1
    Last Post: 10-03-2001, 08:10 AM
  5. how do access and read data in from an excel file
    By hamilton73 in forum C++ Programming
    Replies: 2
    Last Post: 09-26-2001, 10:00 PM