Home > IT Answers > Microsoft Windows > how to use databases made in access or excel in sql
Dragan152
5 pts.
 how to use databases made in access or excel in sql
Access, C#, excel, Import external data, SQL Server, SQL Server database
how to use databases made in access or excel in sql

 

importing readymade databases in sql



Software/Hardware used:
c# , sql
ASKED: January 18, 2011  1:34 PM
UPDATED: January 21, 2011  5:30 PM
RELATED QUESTIONS
Answer Wiki:
Definitely it is possible. U did not mention here which version of Access u r using ! Though try out this tricks.... There is a way called "Upsizing" which helps to convert access database into Sql (here sql means, assuming Sql Server) . To run the Upsizing Wizard in Access, Click Tools > Database Utilities > then point to Upsizing Wizard. And from Excel to SQL (also assuming Sql Server) for this purpose, please visit <a href="http://support.microsoft.com/kb/321686">Here.</a> Though more details r required to provide fruitful answers.
Last Wiki Answer Submitted:  January 19, 2011  4:56 am  by  Subhendu Sen   22,035 pts.
All Answer Wiki Contributors:  Subhendu Sen   22,035 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

In SQL you can use UTL_FILE to read a TXT file created by Excel..

jkeri
 340 pts.
 

Just a minor clarification:

UTL_FILE is not SQL and it cannot be used in SQL Server.

It is a PL/SQL package, and it can only be used on Oracle databases.

carlosdl
 63,535 pts.