Print Page | Close Window

Excel join to SQL Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5546 Printed Date: 01 May 2024 at 7:46am Topic: Excel join to SQL Posted By: Jaki Subject: Excel join to SQL Date 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

Print Page | Close Window