Upsizing from Access to my SQL database

[Teressa64]

I have a database and I am trying to update one of the tables called "members" I use to be able to update my table by upsizing through Access.
I have SQL Server Management Studio Express 2005 and Access 2007.
I can connect and retrieve the table that I have on the DB using Access but I can't upsize.
Is this a MS SQL thing or is it a problem with Access?
And what should I do to fix the problem.
I have over 2500 members and I really don't want to update manually.
Also is there another program I can use to update my DB instead of Access?

Thanks

[TheSmileyCoder]

Im not really sure what your trying to do. Upsize is something you use when you have a access database, and want to seperate the data part into a seperate backend (Which can be either an access database, a MS SQL server, or something different). Updating is to change a value in a row(or multiple rows).

What exactly do you mean by upsizing?

[NeoPa]

I swear I already posted this earlier today :( Evidently not!

I'd suggest using Data Transformation Services (DTS) to upload your Access table into SQL, then work natively in SQL from within Management Studio.

Welcome to Bytes!