Import Excel data using ltrim

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'
 
G

Guest

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

Guest

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

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

Using VBA to format Excel Import 1
Different import results depending on user pc 1
Importing an Excel file 4
Access Tidy up phone numbers 0
import excel data - scientific notation 1
How to import Excel file to Access but the headings have spaces? 5
Import problems from Excel 2000 - Access 2000 3
Import Table Wizard not working 1

Top