import csv file

G

Guest

Hi,

I’m trying to import a csv file into an existing table both have column name
and everything works but if a column has both text and number in the same
column the text data is dropped and I receive a ImportError table that tells
me I have a â€Type Conversion Failureâ€. I have the column set to text but it
still does not work.

Sample:

Date Name Dept FrDept
123 Tim 123 124
123 Mike 456 456
123 Tom U23 U23


The U23 get dropped the rest of the data for that line get imported but not
U23
 
K

Ken Snell \(MVP\)

Use TransferText action in macro or VBA code. Also see Import Specification
(it's the second argument of the TranferText method) for how to assign the
data types for the incoming data.

Both are discussed in Help files; post back if you have questions.
 

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 csv conversion & import spec error 1
Importing csv data 7
Import CSV Type Conversion Failure 3
Import Range 2
Need to convert 1 column into multiple columns 6
import csv truncation 1
Import lots of CSV 4
Can not import .csv file 1

Top