import csv file

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top