[AccessD] Access + SQL Server 2005

SQL Express doesn't include Data Transformation Services, which is the 
tool that supports the Import/Export wizards. You have a couple options...

- Use the Export functionality of Access. (File | Export) You'll need to 
have a DSN created for the database you want to send the data to.
- Use the Access Upsizing wizard.
- Export the data from Access into a text file and then use BCP to put 
the data into SQL.

The first two will be documented in the Access help file, the third in 
SQL Express Books Online.

from Mike Wachal
SQL Express Team

Dan Waters wrote:

>The SS 2005 Book On Line shows a few different methods.  Look under
>'importing data'.
>
>Dan
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Moss
>Sent: Wednesday, December 21, 2005 11:44 AM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] Access + SQL Server 2005
>
>Are there any tools for importing data into SQL Express 2004?
>
>  
>
>>Well, SQL 2K5 is out, and I'm looking at the Express version.  It has 4Gb
>>storage, no workload governor, uses essentially the same Manager as full
>>SQL
>>2K5, and of course it's free of charge.  On the other hand, you can't use
>>the Query Designer in an ADP.
>>
>>I have no experience using Access + SQL, but with the release of SQL 2K5 I
>>figure it's time to move up.
>>
>>I have some general questions, especially for you folks who've been 'in
>>the
>>know' for quite some time now:
>>
>>    Is it possible to use an ADP with SQL 2K5?
>>
>>    If using an ADP is possible, what would be the pros/cons of using an
>>MDB
>>FE vs. an ADP FE with SQL 2K5?
>>
>>    Is using A03 better than using AXP as a FE for SQL 2K5?  If so, why?
>>
>>    Any other known issues for discussion?
>>
>>
>>I hope this starts a discussion over the next few days, and that everyone
>>has a great Holiday Season!
>>
>>Thanks,
>>Dan Waters
>>
>>
>>
>>--
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>>    
>>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada