Need to Move Data to Sharepoint

[RandomNeeds]

I am trying to move my database to sharepoint, and create links to the Sharepoint lists. According to everything I have read, It should be as simple as "Move to Sharepoint" and putting in a link to a site in Sharepoint Services 3.0 environment. I have attempted that, but I keep getting a simple "Microsoft can't perform the export function" error box. I don't get any of the error log tables or anything. It is like the function doesn't even start. Can you assist me with what I can try next?

 

[Banana]

First, do you have permissions to create lists on the SharePoint site you've tried to move to?

Second, do you still get that error even if you created a new database file with only table?

If yes to both questions, we may need to look at the data structure. Post a screenshot from the relationship.

 

[RandomNeeds]

You are a genius! The sample database worked. Then, I checked my relationships in the real database (it is really just a copy of my real database with the tables, that I typically store in a separate Access db, re-imported.) The relationships did not exist. I then re-imported the tables again (with intact relationships) and will be attempting to post the tables again. Will check in a little later when I have had time to upload the real (test) one again.

 

[RandomNeeds]

I don't see where to upload the screenshot, but my last try took a lot longer, but it still failed with "could not export." I do have some tables that do not have relationships to other tables. Do you think that is the problem?

 

[boblarson]

I don't see where to upload the screenshot...

See the instructions here...

 

[RandomNeeds]

http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=33724&stc=1&d=1284505115