Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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-- -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |