Joined: 21 Jan 2009
Location: United States
Online Status: Offline
Posts: 3
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
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
IP Logged