469,574 Members | 1,662 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,574 developers. It's quick & easy.

Need link between MS Excel and MS SQL Server 2000

Hi All,

I am not familiar with MS SQL Server. I have one MS Excel file with datas such as date, name, Address such that. My client given one software to type those datas. The typed datas are stored in one .mdf and one .ldf file. Finally I send this two database files to my client. Now what I need is, a link between MS excel file and .mdf database file. Is it possible? Or any other way is there to transfer data from MS Excel to MS SQL Server Master Database File.

With Regards,
+91 9940304858


Thank you very much. I import the excel file to my MS SQL Server 2000 .mdf file as per your information.(using Enterprice Manager)

Now I have one more doubt.

In that database there are so many tables present. User created tables and system tables. I will take care of that user created tables. I import the data from excel file to .mdf file instead of using my client's customized tool. If my client have chance to find, all the data had entered are import from excel instead of using customized tool?
If yes, where can he see that details?
Can I change that data too to my requirement?

With Regards,
+91 9940304858
Feb 4 '08 #1
0 1010

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by chanmm | last post: by
1 post views Thread by Steven | last post: by
2 posts views Thread by smtwtfs007 | last post: by
reply views Thread by smtwtfs007 | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.