Import Excel data using ltrim

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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'
 
Continue.... How can I import the Excel data into my Access table WITHOUT the
preceding invisable characters?
 
Bring into a temp table. Use an append query with the LTrim function on that
field to put the data in the permanent location.
 
Back
Top