Access linked to SharePoint

[Guest]

To the people who know more than me...

I'm running SharePoint Service 2.0 and currently have linked tables in
Access 2003 pointing to 10 lists. The structure of these lists are exactly
the same.

I need a way to merge all the information from the 10 tables into 1 table
and make a way for this to happen on a daily at a given time.

Thank you in advanced for the help!

 

[Larry Linson]

To the people who know more than me...

I'm running SharePoint Service 2.0 and currently have linked tables in
Access 2003 pointing to 10 lists. The structure of these lists are exactly
the same.

I need a way to merge all the information from the 10 tables into 1 table
and make a way for this to happen on a daily at a given time.

Are you familiar with UNION and UNION ALL Queries/SQL Statements? That will
allow you to concatenate the information from all ten (linked tables)...
then you could convert that into an Append or a Make-Table Query to create
the new table. As these would be stored Queries, it would be simple to
execute them from VBA code.

Larry Linson
Microsoft Access MVP

 

[punjab_tom]

I would reccomend staying away from MDB against Sharepoint; it is too
slow to be useful.

You should keep your data in SQL Server; and you can use SQL Server
tools in order to get to this data in a more logical format.

in other words; why worry about pulling 10 lists-- and jamming them
back into one table-- when they are already stored in one table on the
sharepoint side?

-Tom

 

[Guest]

Hello Punjab,

I guess you didn't read my name on this post... =)

 

[Guest]

Thanks Larry!!! I'm researching these types of queries and should be able to
implement your suggestions. Your reply was exactly what I was looking for!

 

[punjab_tom]

what do you talk of?

-Tom

Hello Punjab,

I guess you didn't read my name on this post... =)

 

[Granny Spitz via AccessMonster.com]

Hello Punjab,

I guess you didn't read my name on this post... =)

Don't mind him, hon. His solution for everything is to use ADPs and SQL
Server. Cell phone battery died? Use SQL Server. Got indigestion? Switch
to ADPs. Neighbor's dog kept you up all night barking? Should've used SQL
Server!

 

[Guest]

Thanks Granny, we are all learning at our own pace. I have SQL query and
design classes scheduled for February!!! Yay!

 

[Guest]

Hi Tom, we are implementing SharePoint Portal early next year which will use
our SQL backend. I'm still learning SQL and how to query so for now, i'll use
Access. Thank you for your post!!!

 

[Granny Spitz via AccessMonster.com]

Thanks Granny, we are all learning at our own pace. I have SQL query and
design classes scheduled for February!!! Yay!

You'll probably find it challenging but once you get the hang of it, you'll
find out how powerful it is ... and *you've* got that power at your
fingertips! Best of luck to you.

 

[punjab_tom]

Granny

hey **** you.

ADP doesn't need 2/3rds of the workarounds that MDB needs.

Maybe instead of using bandaids to make a sweater; maybe you should use
a REAL TOOL

-Tom

 

[aaron.kempf]

MDB against sharepoint is TOO SLOW to be effective.


use real SQL Server tools

-Aaron

 

[punjab_tom]

yes my friend Hari said that it was slow also.

Can we use MDB to interact directly with the SQL table instead of going
through this Sharepoint Interface?

-Tom