Dick,
Goes like this:
If you want to use csv file
1. Have MS Access export DB to csv file.
2. Make a web page that uploads file
eg:
<form method="post" action="convertDB.cfm" enctype="multipart/form-data">
<input type="file" name="your_database">
<input type="submit" value="Upload">
</form>
Have the convertDB.cfm page do something like this:
<cffile
action="upload"
filefield="yourdatabase"
destination="/your_database_path/"
nameconflict="Overwrite">
<cfdirectory
directory="/your_database_path/"
name="your_directory"
sort="datelastmodified">
<cfoutput query="your_directory" maxrows="1">
<cfhttp method="get"
url="http://www.your_name.com/your_database";
delimiter=" "
textqualifier=""
columns="column1, column2, column3"
name="Your_Query">
</cfhttp>
</cfoutput>
Then make a query to write/update the records.
This converts your MS Access database into the mysql database. To convert
it back to MS Access, write a cfm page that queries your mysql DB and into
a csv file.
Brett
At 10:52 AM 10/9/02 -0700, you wrote:
>Brett
>
>OK, you go through an intermediste CSV file.
>
>Is the MySQL db an intermediate to another db or the end result?
>
>Dick
>
>
>On Wednesday, October 9, 2002, at 09:55 AM, Brett Frisch wrote:
>
> > I have run into a similar situation as well. I no longer do cf and
> > windows
> > unless the customer has to have it. Anyway, a recent client has a
> > retail
> > store with POS (point of sale) software. We export all the info into a
> > comma delimited text file. I built a interface so the customer
> > uploads the
> > file to the server, i then have cfhttp decipher the text file and put
> > it
> > into mysql DB. Your customer could do the same thing with access. Or
> > they
> > could use the MyODBC driver
> > (http://www.mysql.com/products/myodbc/index.html) to do the trick. Of
> > course you may not want your client to have access to the DB on the
> > server
> > that easily. Maybe option #1 would work better? Either way, these
> > are two
> > options that work well.
> >
> > Brett
> >
> >
> > At 09:06 AM 10/9/02 -0700, you wrote:
> >> There is a situation that I encounter & I wonder how others handle it
> >>
> >> It is fairly common (almost a given), that a new client will have
> >> some
> >> or all of his data available in offline MS-Access databases.
> >>
> >> It is usually necessary to manipulate this data (validate, normalize,
> >> etc) to convert it into a usable online database (storing it in a more
> >> robust RDBMS).
> >>
> >> I have found that CF is an excellent tool for this.
> >>
> >> I normally just upload the MS-Access mdb file to the hosting service.
> >> Then I write CF programs that convert the data from MS-Access to, say
> >> SQL-Server, or Oracle.
> >>
> >> No problem, as long as the host service is running on a windows
> >> platform -- MS-Access is usually supported.
> >>
> >> But what happens if the Host uses a non-windows platform?
> >>
> >> How do you read a MS-Access database on, say a Linux Box.
> >>
> >> I guess you could capture the Access database into SQL-Server,
> >> offline, if you had:
> >>
> >> 1) a windows machine
> >> 2) MSDE or SQL-Server
> >> 3) MS-Office
> >>
> >> This extra step gives you a mirror of the client's MS-Access db on
> >> SQL-Server -- you still need to manipulate it for validation,
> >> normalization, conversion to online, etc.
> >>
> >> What do you do if you need to go to some other (not SQL-Server)
> >> RDBMS,
> >> that doesn't have the ability to capture Access databases?
> >>
> >> The problem gets compounded if the client requests periodic creation
> >> of
> >> an offline copy of the online database
> >> -- for offline analysis, etc.
> >>
> >> Is this an issue that any of you run into with any frequency?
> >>
> >> How do you handle it?
> >>
> >> (Of course the easy out is just host on windows platforms that support
> >> Ms-Access -- but that is totall the wrong reason to make a hosting
> >> decision).
> >>
> >> TIA
> >>
> >> Dick
> >>
> >>
> >>
> >>
> >>
> >>
> >
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
