By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,434 Members | 2,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,434 IT Pros & Developers. It's quick & easy.

Need link between MS Excel and MS SQL Server

P: 7
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.
Thanks,

With Regards,
bala
+91 9940304858
Jan 31 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
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.
Thanks,

With Regards,
bala
+91 9940304858

yes...use your enterprise manager and import your excel file..

-- ck
Jan 31 '08 #2

deepuv04
Expert 100+
P: 227
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.
Thanks,

With Regards,
bala
+91 9940304858
you can also use query to get the data from excel sheet as follows
/* reading data from excel sheet */

sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE
GO

insert into tablename(col1,col2.....)
select col1,col2.....
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=filepath',
'SELECT * FROM [Sheet1$] where col1 is not null')

NOTE : your excel file must be on your database server

thanks
Jan 31 '08 #3

P: 7
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.
Thanks,

With Regards,
bala
+91 9940304858

Hi,

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

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 see that details?
Can I change that data in system created table?
Thanks,

With Regards,
bala
+91 9940304858



yes...use your enterprise manager and import your excel file..

-- ck
Feb 4 '08 #4

Post your reply

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