By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,248 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,248 IT Pros & Developers. It's quick & easy.

help in importing excel spreadsheet !!

P: n/a
Hi folks.

My project has 2 tables:
tblBook - ISBN [primary key], Title, Author, Year, Publisher, Total
tblAcc - AccNo [primary key], ISBN [foreign key], Status (combo box),
Borrow (check box)

Example:
tblBook
013089592X | ... |... |... | ... | 3
0131103628 | ... |... |... | ... | 2
tblAcc
M0200 | 013089592X | On Shelf | ...
M0201 | 013089592X | On Shelf | ...
M0202 | 013089592X | On Shelf | ...
M0203 | 0131103628 | On Shelf | ...
M0204 | 0131103628 | On Shelf | ...

I am suppose to allow the user to import an Excel spreadsheet into
tblBook, which I have done successfully. However, my problem is that I
have to update tblAcc, and I prefer to automate this process if
possible, but I don't know how. AccNo is suppose to be an incrementing
number. My idea was:

1) the user types in the details of the book into the Excel
spreadsheet.
2) the user imports the spreadsheet into tblBook.
3) tblAcc will use Total in tblBook to generate / auto-increment AccNo
and fill in the rest of the details (i.e. copy the number of ISBN
based on Total, set Status to "On Shelf", set Borrow to false)

Numbers (1) and (2) works, but I am unable to do (3). Can anyone give
me any pointers and ideas on how to achieve this? Or is there a better
way? Thanks in advance.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.