Adding folders (directories) with other file types (excel)

[a]

I did have my excel files stored in directories outside of my 'OneNote
Notebooks' directory, but in order to consolidate directories and not have
duplicate directories (one set for excel files and a second set for OneNote
files) I'd like to move both OneNote and Excel files into the same
directories.

Is this typically the way it should be done? Does this create any problems
for OneNote in having these excel files and directories inside the OneNote
directories? Size, performance degradation?

I see that the next version of OneNote is going to have features for
handling Excel files...will the Excel files be stored inside the OneNote
directories then? Will I be able to continue to store my data in an SQL
database and link to it via Excel and have access to this data in OneNote or
will OneNote break the SQL-Excel connection?

Clueless

Thanks

 

[Ilya Koulchin]

I did have my excel files stored in directories outside of my 'OneNote
Notebooks' directory, but in order to consolidate directories and not have
duplicate directories (one set for excel files and a second set for OneNote
files) I'd like to move both OneNote and Excel files into the same
directories.

Is this typically the way it should be done? Does this create any problems
for OneNote in having these excel files and directories inside the OneNote
directories? Size, performance degradation?

You should be fine. If you move the directories with excel files into
your notebooks, OneNote will show those directories as section groups,
but will not show the files within them. Otherwise, they'll behave just
like any other section group.

I see that the next version of OneNote is going to have features for
handling Excel files...will the Excel files be stored inside the OneNote
directories then?

Not sure where you heard that from. OneNote 2007 has the ability to
attach files from any app directly into a OneNote page (not sure if
OneNote 2003 had that feature as well). Beyond that, there isn't any
special handling for Excel files, or any other file type.

Will I be able to continue to store my data in an SQL

database and link to it via Excel and have access to this data in OneNote or
will OneNote break the SQL-Excel connection?

OneNote doesn't have any features to connect to SQL or other databases.
It also doesn't interact with any non-OneNote files that're present
within the notebook directories, so it should have no effect on the
SQL-Excel connection.

Ilya