dbTalk Databases Forums  

linked excel table - reference named range within a database field ?

comp.database.ms-access comp.database.ms-access


Discuss linked excel table - reference named range within a database field ? in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DMolter
 
Posts: n/a

Default linked excel table - reference named range within a database field ? - 10-30-2005 , 06:12 AM






I'm trying to define a math problem in excel, so for example a 4 cell block
where A1 contians nothing, B1 contains the number 2, A2 contains the '+'
sign and B2 contains the number 3, forming a simple addition fact. I want
to reference this block of cells as a record in access to print out a math
worksheet as a report.

Eventually I'll change the numbers in the problem to =int(rand()*10)+1 to
generate random addition facts, or any other type of problem and can form in
excel.

Bottom line: can I reference a named range as a field in a database record,
update that linked field in the original excel spreadsheet, and print out
that range, correctly formatted (maintaining the format from excel), in an
access report?

If possible, the named ranges could be of variable size, as I would use this
database to test students on a variety of math skills, record their
progress, and print customized tests for each student depending on their
individual progress.

Please help !!!




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.