Hi Experts ;)
I'm having trouble exporting data to my database in sql server 2005. Can anyone help me perhaps? The data I want is located in text files (holds personnel time management data), so what I would like to do is import that data to sql server but the flat file import option doesn't work :(.
So I also have the data in an excel file with sheets of each personnel and the data. But when I try the excel file import it also doesn't work. Gives the error of something like the notes column has truncated data...?
Can anyone give me some additional option on how I can get this data into sql..?Will really appreciate it!
Here is an example of how the data looks in the text file:
2010/03/02 12:42:05%#%2009/01/05%#%Admin%#%Langebaan Office%#%True%#%False%#%8.5%#%%#%2009/06/25 12:45:25%#%%#%%#%%#%%#%True%#%False%#%%#%
2010/03/02 12:42:12%#%2009/01/06%#%Admin%#%Langebaan Office%#%True%#%False%#%8.5%#%%#%2009/06/25 12:45:25%#%%#%%#%%#%%#%True%#%False%#%%#%
2010/03/02 12:42:16%#%2009/01/07%#%Admin%#%Langebaan Office%#%True%#%False%#%8.5%#%%#%2009/06/25 12:45:25%#%%#%%#%%#%%#%True%#%False%#%%#%
2010/03/02 12:42:20%#%2009/01/08%#%Admin%#%Langebaan Office%#%True%#%False%#%8.5%#%%#%2009/06/25 12:45:25%#%%#%%#%%#%%#%True%#%False%#%%#%
2010/03/02 12:42:24%#%2009/01/09%#%Admin%#%Langebaan Office%#%True%#%False%#%8.5%#%%#%2009/06/25 12:45:25%#%%#%%#%%#%%#%True%#%False%#%%#%
2009/06/01 09:18:14%#%2009/05/31%#%No Work%#%%#%False%#%False%#%%#%%#%%#%%#%%#%%#%%#%True%#%True%#%%#%
2009/06/02 09:42:30%#%2009/06/01%#%Admin%#%Langebaan Office%#%True%#%False%#%8.5%#%%#%2009/05/22 13:33:43%#%%#%%#%%#%%#%True%#%False%#%%#%
And the data in the spreadsheet is obviously in columns.