Import Access File

Is there a way to import an access table into Microsoft SQL Server Express with Server Management Studio? I prefer not to use the upsize tool from access. Another option would be to import from a text file, if someone can explain how to do this.

Thanks

hi,

nope, this is not "available"... but you could use a linked server approach..

regards|||

Microsoft has an excellent tool for migrating Access tables: SQL Migration Assistant for Access. Try:

www.microsoft.com/sql/solutions/migration/access/default.mspx

If you just search the Microsoft site for SQL Migration Assistant for Access it will give you several links to follow.

Hope that helps.

Don Seydel