Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Excel join to SQL Post Reply Post New Topic
Author Message
Jaki
Newbie
Newbie


Joined: 21 Jan 2009
Location: United States
Online Status: Offline
Posts: 3
Quote Jaki Replybullet Topic: Excel join to SQL
    Posted: 18 Feb 2009 at 11:41am
I would like to do a full outer join between a spreadsheet and an SQL table. I need to join on phone number however the table has it described as string and the spreadsheet sees it as a number.  Does anyone know the way to convince Excel the phone number is string?
I have VBA that reads the spreadsheet row by row and does some cleanup.
Thanks
Jim
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.