import error

L

Lez

Hi Guys,

I am trying to import a CSV file into a tempTable using the following
command:

DoCmd.TransferText acImportDelim, 0, "PROD", _
strSS, True, ""

However it keeps failing at the 0 however the import spec states 0 as the
type to use:

Any suggestions please

Thanks
 
D

Douglas J. Steele

The syntax for the TransferText method is:

DoCmd.TransferText [transfertype][, specificationname], tablename,
filename[, hasfieldnames][, HTMLtablename]

In other words, you're trying to pass 0 (a numeric value) as the
specificationname (a text value)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Spec CSV 7
Problem with access acImportDelim importing csv with headers 1
Import Excel CSV file into Access 2007 2
Spreadsheet Import 1
Data Import question 4
Import files into access 1
import problem 1
import csv conversion & import spec error 1

Top