I'm looking for fresh Idea's on how to setup a SQL database

[Mick56]

Hi everyone

I made a database program for a person in the USA (I am in Ireland) and installed it on their computer
using Teamviewer and the program works fine
I setup the SQL database inside VB2008 and manually entered some data from an online spreadsheet on Google,
and they have entered data from the same spreadsheet ever since.
Over a few weeks I made some small changes, (add another query, Printout, etc) and everytime I installed
the new version of the program their updated database was kept. (my version of the database had only some data in it).
I installed by using OneClick in VB.
The database has 4000 rows and 12 columns thats 48000 fields and more rows will be added over time.

I want to totally rewrite the program with some new features in it and also be adding couple of more new columns to
the database
The person has been keeping the online spreadsheet up to date as a backup, but in doing so, have entered data wrong,
text where dates should be, text and dates in others, entered years instead of dd/mm/yyyy and so on.
I have downloaded the spreadsheet into 2003 excel and have moved the text to text columns, dates to date colums etc
but some cells in some columns are formatted as text others as dates,
also in the mix is that in the USA its MM/DD/YYYY and its DD/MM/YYYY here in Ireland and when I try to change the formating
I keep getting numbers.

I installed SQL server management studio 2008 and imported the data from the excel spreadsheet and its not working the
way I want
I have even copied row by row and still not working right, some cells have dates in them, but when I copy them to the database
I get blank fields, others cells with dates copy ok.

Do I setup the database inside VB2008 (the last time I did, it worked fine) and start from cell A1 copy or type in the data
(something I'm not looking forward to)

Any fresh idea's are more than welcome.

Thanks
Mick

[dunfiddlin]

Can you not simply obtain a copy of the client's database? If you have access to all the data in the spreadsheet there wouldn't appear to be any security issues.

[SeanGrebey]

Get a copy of their database, restore it locally, write an SSIS package to transfer the data from it into your new database?