Transferspreadsheet - datatype error

B

Beginner

When I use Transferspreadsheet to import an excel file to
a temporary table, the datatype of a particular field is
assumed by Access as Number and most of the data for the
field, which are Text(eg. 100123-1,10022CB100 etc) are
just empty in the table.

How do I overcome this?

Any help is appreciated

Thanks
Beginner
 

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

Top