how to use databases made in access or excel in sql

5 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • jkeri
    In SQL you can use UTL_FILE to read a TXT file created by Excel..
    355 pointsBadges:
    report
  • carlosdl
    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.
    69,065 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following