Import excel to access

C

Carol Gunn

Since upgrading to OfficeXP my usual import of excel
files to access (for reporting purposes) is not importing
all product codes. The codes are a mix of alpha-
numeric. I have tried making them "text" in excel before
importing, which did bring the numeric codes across but
left the alph-numeric mix blank.

Can anyone help?
 
J

Joe Fallon

Since Excel is not a database, using "mixed" data types in a column causes a
problem when Access has to "guess" which one to use. Access examines the
first 15 rows (or so) and makes a guess. If you want to "force" Access to
guess a text data type then make the first entry in that column a text
value. The reason you get errors is that the first 15 rows are all numeric
and then the text data shows up after Access has already guessed the data
type to be Numeric.

The way to make a text value in your data of numbers is to include a
character!
e.g. 123A
 

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 via TransferSpreadsheet, receiving "type conversion fail 1
Problems importing "number/text" fields to Access from Excel 2
Differences Between Two Spreadsheets ? 2
Import data from excel 1
CSV Data/Import Issues 1
Type Conversion Failure importing number as text 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Import from Excel to Access 1

Top