View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IgelSitter IgelSitter is offline
external usenet poster
 
Posts: 1
Default problem about sending data in Excel to an Access database

hi all,
I have a sheet and I wanna send the data to an Access database.

An example is shown as following:

A B
1 names scores
2 Jack 80
3 Tom 90
4

although A4 and B4 seem to be blank , there are functions hidden.
these functions enable there are certain records in A4 and B4 if they exist
really.
and if the records don't exist,A4 and B4 seem to be blank.

so,problem is coming:
when I lead in the data to the database,Access maybe don't view A4 and B4 as
blank.
how should I do?