Importing from Excel to Access

J

Jamie Dickerson

I would like to import an excel worksheet to an Access Table. The problem I
am having is that the first field of the worksheet includes both text and
numbers. The import wizard will not allow me to change the Field Type and all
the text entries are left out. Is there a way around this?
 

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

Importing an Excel File 1
Importing Text Fields in Excel 2
Access Subscript out of range when importing into access 2010 from excel 0
Change Field Data Type? 1
Importing Text Files Into Access 1
Type Conversion Failure importing number as text 1
importing excel 1
Importing Excel file into Access -- format errors 7

Top