To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.admin.databaseOpen lugnet.admin.database in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Administrative / Database / 80
79  |  81
Subject: 
Re: A database question
Newsgroups: 
lugnet.admin.database
Date: 
Mon, 7 Dec 1998 20:29:19 GMT
Viewed: 
517 times
  
On Thu, 26 Nov 1998 13:05:03 GMT, "Huw Millington"
<hmillington@cix.co.uk> wrote:

Steve Bliss wrote in message <365c1013.5669348@lugnet.com>...
Once upon a time, "Jim Hughes" <hughesj@one.net> wrote:

If you go with Access, take the time to write a VBA function to export
the data to CSV format.  That way, you can share with everyone, and
you won't have a export-headache each time you update the database.

Access provides this facility built-in so there's no overhead in keeping it
in Access, then creating a query to export the table(s)/fields exactly as
required.

But writing a function is MUCH more flexible than the built-in export
facility. PLUS you can write it such that you do not have to do
anything but press a button to get this file generated, MUCH nicer,
IMHO (or perhaps I'm just biased because this is one of the areas my
friend worked on in Access)

Sarah Heacock
sarah@eskimo.com



Message is in Reply To:
  Re: A database question
 
Steve Bliss wrote in message <365c1013.5669348@lu...et.com>... (...) Access provides this facility built-in so there's no overhead in keeping it in Access, then creating a query to export the table(s)/fields exactly as required. Huw (26 years ago, 26-Nov-98, to lugnet.admin.database)

8 Messages in This Thread:




Entire Thread on One Page:
Nested:  All | Brief | Compact | Dots
Linear:  All | Brief | Compact
    
Active threads in Database

 
LUGNET Guide updates (Fri 20 Sep 2024)
10 hours ago
Custom Search

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR