Import Excel data using ltrim

S

SharonInGeorgia

I need to import an Excel spreadsheet (that is a download report from another
system) into my database. There is one TEXT field in the Excel database that
contains some blank spaces in front of the field. The field may contain a
mixture of numbers and letters and sometimes has a '0' as the first charater.
Example of data: '0910', '810', '678WX', '0001'. The spaces appear in the
table when I do a 'Transfer Spreadsheet' or a "Select statement' and the '0'
are eliminated when I set the field as a numeric field'
 
S

SharonInGeorgia

Continue.... How can I import the Excel data into my Access table WITHOUT the
preceding invisable characters?
 
K

KARL DEWEY

Bring into a temp table. Use an append query with the LTrim function on that
field to put the data in the permanent location.
 
Top