|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
August 12th, 2003, 05:14 PM
|
|||
|
|||
|
Access export to SQL server
I've recently heard that it is possible to build a database in Access and use the export command to take the tables and data in the Access database and convert it for a SQL server database. Is this correct? If so, does it automatically generate the necessary code to use in ASP pages to query the data?
Are there any online tutorials or articles that dicuss how to do this? Any insight on this is appreciated. Thanks in advance. -Dman100-
|
|
#2
August 13th, 2003, 09:30 AM
|
||||
|
||||
|
ASP has nothing to do with it. I do not know that you can export an Access database to SQLServer, but I do know for sure you can import an Access db into SQLServer. The ASP code, one would presume, would work just as well on SQLServer once the target db had been changed.
IMHO your time is better spent learning how to build a database in SQLServer directly rather than doing it in Access first, then porting it to SQLServer.
__________________
Left DevShed May 28, 2005. Reason: Unresponsive administrators. Free code: http://sol-biotech.com/code/. Secure Programming: http://sol-biotech.com/code/SecProgFAQ.html. Performance Programming: http://sol-biotech.com/code/PerformanceProgramming.html. It is not that old programmers are any smarter or code better, it is just that they have made the same stupid mistake so many times that it is second nature to fix it. --Me, I just made it up The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore, all progress depends on the unreasonable man. --George Bernard Shaw
|
|
#3
August 16th, 2003, 02:02 AM
|
|||
|
|||
|
Alternately,
You may link MS-Access table to SQl Server, through MS-SQl server "linked servers"and have your tables imported to Sql Server, with a single line of code. Cheers
|
|
#4
August 30th, 2003, 12:52 AM
|
|||
|
|||
|
AS mitakeet said
ASP has nothing to do with it. I do not know there is any command that you can export an Access database to SQLServer, but I do know for sure you can import an Access db into SQLServer. Here one simple way You can Import Ur Access Table Inot SQLServer .. 1:go for Export and Import (DTS Wizard) 2: then select source Microsoft Access Filename(browse the .mdb file) , Username & password(if give) then click next 3:select Destination as Microsoft OLEDB Provider for SQL Server and leave as Server as (local) then 4: select Use SQL Server authentication , Username,password(must), 5: then click refres to select the database what if u newly created in SQL or it will import to Default Database of that User then click next 6: then give copy table it will automatically copy the MSAccess table to ur SQL Server Database
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Access export to SQL server |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
