How many tables and fields do you have to import? This is easy to do from a
CF template. Just read from one db and do inserts/updates into the other.
Doing it in CF, you can get as creative as you need -- just one simple
example: if a field was incorrectly defined as text in the original db and
you need to convert it to numeric, you can replace with zero's wherever you
find NULL's or empty strings.
Jim
----- Original Message -----
From: "Jonathan R. Karlen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, December 12, 2000 12:58 PM
Subject: OT: DBF into Access
> Greetings �
>
> I am producing a CF web application for a client who has his inventory
> available in a DBF file.
>
> I�m developing in Access (for later conversion to SQL Server) and I want
to
> be able to import their data into Access. If I import it as a DBF file I
> can�t change field properties or anything. Is there a way to import it
and
> convert into a native Access table?
>
> TIA �
> Jonathan Karlen
>
> ****************************************************
> Jonathan R. Karlen
> President
> Karlen Internet Solutions, Inc.
> Web Site and Application Development
> http://www.karlen.com
> [EMAIL PROTECTED]
> (914)-923-2116
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
