Subject: Re: Database conversion
From: Greg Jetter (greg@lazymountain.com)
Date: Fri Oct 26 2001 - 09:58:39 AKDT
On Thursday 25 October 2001 08:57 pm, Mike Tibor wrote:
> On Thu, 25 Oct 2001, Greg Jetter wrote:
> > From what I understand access databases are comma seperated data .
> > Sooooo you should be able to dump the data base to a file and then use a
> > web scripting language such as PHP or PERL to manipulate the data.. I
> > even beleave both the above scripting languages have modules or
> > functions to handle access files directly..
>
> Comma delimited is not the native form of an Access database, but it can
> export to a comma delimited text file. You can also export in tab
> delimited and other formats as well. The resulting file can be imported
> into mysql using mysqlimport.
>
> If you're handy with PHP or Perl it shouldn't be tough to do a web
> interface. If not it may just be easier to hire someone to it, assuming
> that's an option.
>
> Mike
Thanks for the info , I don't use Access or any other Microsoft product ,
I'm strickly Linux so I answered the question based on what I have heard
about Access. I remebered hearing that it used a form of comma seperated
data ... If I ever have tyo deal with that I'll keep your advice in mind.
Greg
This archive was generated by hypermail 2a23 : Fri Oct 26 2001 - 09:31:42 AKDT