Ah!
I had this same issue.
Michael Sheldons CFX tag DelimToQuery works a treat. Very fast.
Gordon
At 16:31 08/08/00 -0400 Ben Densmore said....
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0009_01C00156.1A3B8F20
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Can anyone tell me the best way or give me some ideas on how to take =
>data that is in multiple csv files and suck all of it into multiple =
>tables in an access database? I'm currently working on a project where I =
>need to do this and the people who wrote the DB and the csv files aren't =
>helping much at all, if no one has any ideas does anyone know of a list =
>similar to this one that is database specific.
>
>Thank You,
>
>=20
>Ben Densmore
>Webmaster
>eSupport.com, Inc.
>TouchStone Software Corp.
>http://www.esupport.com
>http://www.checkit.com
>
>------=_NextPart_000_0009_01C00156.1A3B8F20
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META http-equiv=3DContent-Type content=3D"text/html; =
>charset=3Diso-8859-1">
><META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
><STYLE></STYLE>
></HEAD>
><BODY bgColor=3D#ffffff>
><DIV><FONT face=3DArial size=3D2>Can anyone tell me the best way or =
>give me=20
>some ideas on how to take data that is in multiple csv files and =
>suck all=20
>of it into multiple tables in an access database? I'm currently working =
>on a=20
>project where I need to do this and the people who wrote the DB and the =
>csv=20
>files aren't helping much at all, if no one has any ideas does anyone =
>know of a=20
>list similar to this one that is database specific.</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>Thank You,</FONT></DIV>
><DIV> </DIV>
><DIV> </DIV>
><DIV><FONT face=3DArial size=3D2>Ben =
>Densmore<BR>Webmaster<BR>eSupport.com,=20
>Inc.<BR>TouchStone Software Corp.<BR><A=20
>href=3D"http://www.esupport.com">http://www.esupport.com</A><BR><A=20
>href=3D"http://www.checkit.com">http://www.checkit.com</A></FONT></DIV></=
>BODY></HTML>
>
>------=_NextPart_000_0009_01C00156.1A3B8F20--
>
>-------------------------------------------------------------------
-----------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t
alk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
