import error / copy and paste edit

  • Thread starter Thread starter jer
  • Start date Start date
J

jer

Dear all
I tried importing an excel worksheet into a new access
table, however some rows did not import because there were
some blank cells in the spreadsheet (my guess). To get
around this I copied the excel wksheet and paste append to
a new table (datasheet view). This seemed to work fine,
however, my excel sheet has 15 columns and the default
datasheet view has only 10 columns. Is there anyway to
change the number of columns in a default view to 15 or
more.
Or, failing this how do you import blank cells??
thanks
jer
 
Access imports "rectangular" data from Excel very nicely.
(There are many quirks, but if you are aware of them it works OK.)

I suggest you copy the Excel "rectangle" of data to a new workbook and then
import that into Access using the Wizard.

=====================
General tip:
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
 
Back
Top