View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Web Query? Is This Possible?

I think the first choice is better, but I don't completely understand what
you mean. I think data in separate cells is best; this is for a database
that I'm developing. Basically, this is going into a SQL Server DB. I need
to be able to query by different criteria. I don't know how to do this kind
of thing using SQL Server, or even Access, so I opted for Excel. I think if
everything is in one sheet, with distinct data in distinct cells, it will
just be easier to Import into SQL Server; one single 'flat file'. Do you
know if this can be done using SQL Server or Access? Excel is perfectly fine
as an interface; just one more step to transfer to SQL Server, and this is
going to save me soooo much time.

Can you send me an email?


Thanks for everything!!
Ryan--
--