Hi,
I am trying to import an excel file located on a sharepoint site to a table in my database. All I can seem to do is import the list structure then drill into a hyperlink in that list structure and it opens the file in excel.
Is there not a way to import the data in that spreadsheet into a table as if you were importing it from your desktop?
I must be missing something
Thanks