Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2010, 03:18 AM
Karthick Karthick is offline Need an Automated sql query for the Excel file Windows XP Need an Automated sql query for the Excel file Office 2007
Novice
Need an Automated sql query for the Excel file
 
Join Date: Dec 2009
Posts: 7
Karthick is on a distinguished road
Default


HI Bjorn,
Thanks a lot for the solution!!
I apologies that i forgot to mention the version of Excel that I’m using.

Sorry, I'm using excel 2007. Please rephrase your solution so that it adapts to excel 2007.
Reply With Quote
  #2  
Old 12-20-2010, 04:52 AM
BjornS BjornS is offline Need an Automated sql query for the Excel file Windows Vista Need an Automated sql query for the Excel file Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
basically the function you need you will find here: "Data / From text". Try this and the help function attached to it. This is the corresponding function in Excel 2007.

To guide you through each step would unfortunately cost me too much time. Now you know the way to start. I am sure you find your way to a good final solution by this. Good luck!

Kind regards
Bjorn
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Automated reminders paulgy80 Outlook 1 08-21-2010 04:35 PM
Automated Letter Sections gladfan Word 0 08-11-2010 01:53 AM
Text Box Query Meljord Word 3 12-15-2009 12:25 PM
Automated Functions?? nickypatterson Outlook 0 08-27-2009 01:50 PM
Mail Merge Query kangabanga Mail Merge 0 09-25-2008 04:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft