ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   problem about sending data in Excel to an Access database (https://www.excelbanter.com/excel-programming/335400-problem-about-sending-data-excel-access-database.html)

IgelSitter

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?


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com