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.

Recommended Answers

All 3 Replies

Me again..

Does anyone perhaps know some useful site where they show some examples similar to the following??

I want to export specified columns to a an existing xls file (Used as my template). In the file there are sheets with sheet names of every user. The cell ranges differ from each other so the links they gave me above isn't quite what I wanted..

Please help?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.