Re: [sqlite] Stitching together Text Files into a New Database

1. Define a separate file in SQLite for each campaign, with the three columns you need: CAMPAIGN1 Time number (assuming the values are always numbers; use TEXT if they contain a mix of letters/numbers) TagA number TagB number CAMPAIGN2 Time TagA TagB Etc. 2. Import each of your text files

Re: [sqlite] Stitching together Text Files into a New Database

Lorenzo Isella writes: [...] if you've no idea where a db can help you and if you don't have time to investigate this and the possibilities a db offers you my suggestion is: import your 3 or 5 files into a spreadsheet, add a column for your different campaign and that's it

[sqlite] Stitching together Text Files into a New Database

Dear All, I am quite new to databases in general and sqlite in particular. I have a number of data files which are nothing else than text files with a pretty simple simple structure: there are only 3 columns of integer numbers, something along these lines 123 1000 199 123 1100 188 125