Posted by Danny J. Lesandrini on 12/20/05 19:46

Have you tried using a saved import spec with the data typ defined?

--
Danny J. Lesandrini
dlesandrini@hotmail.com
http://amazecreations.com/datafast


<ckirby@mindspring.com> wrote ...
> I've got a csv that I am trying to import into a SQL Server (2000)
> table through an adp (Access 2000). The form used gives the user the
> ability to browse for a file, then will import the file into a temp
> table for processing using this vba code:
>
> DoCmd.TransferText acImportDelim, , "tmpPaTimeClock2", Me!TimeFileName, False
>

• Next in forum: Re: Cannot resolve collation conflict for equal to operation.
• Prev in forum: SQL/ASP - Timout Problem w/ Particular Statement
• Thread view: Re: TransferText dropping fractions

[Reply to this message]