Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to link Access Reports to SQL 2005
Hi, I've imported an access database to SQL 2005. There are some existing access reports that I need to link them to SQL server 2005. Is there a way to do this? It seems that I can use SQL 2005 reporting servises to create the forms, but I'd like to temporary link access reports to SLQ 2005...- weldrick
- Thread
- Replies: 0
- Forum: Microsoft: Access Reports
-
Problem with Import Excel to SQL 2005
Hi, I'm using the following VB code from Microsoft web site to import an excel sheet to SQL 2005. If I run it for the first time, there is no error, but no table is created in SQL server. If I run it for second time, it gives me a run-time error: Table 'test' already exists. But this table does...- weldrick
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
How to import ACCESS Query to SQL 2005?
Hi! I'm using the SQL DTS to upsize access database to SQL 2005. It imports tables properly, but for queries, it imports the query output to SQL 2005 as a table . What I want is just to import the query text as a view in SQL 2005. How can I do this? Suggestions, ideas will be appreciated...- weldrick
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Integration Services (SSIS)
