469,647 Members | 1,669 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Need link between MS Excel and MS SQL Server

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
3 4729
ck9663
2,878 Expert 2GB
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
227 Expert 100+
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
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.

Similar topics

8 posts views Thread by W. de Jonge | last post: by
12 posts views Thread by Mourad | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.