Using VBA to format Excel Import

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SharonInGeorgia - 30 Jan 2006 14:40 GMT

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'

.... How can I use VBA to import the Excel data into my Access table WITHOUT
the preceding invisible characters?

Reply to this Message

Joe - 30 Jan 2006 20:24 GMT

Since you already have the data ina table using the transfer spreadsheet,
you could just us the LTrim, RTrim, and/or Trim functions in an update query
to remove leading and trailing spaces.

> I need to import an Excel spreadsheet (that is a download report from
> another
[quoted text clipped - 12 lines]
> WITHOUT
> the preceding invisible characters?

Reply to this Message