Hi, I know a lot of you have been asking how to get your Sources into Clooz without having to type them in. Ok, here's the scoop on how I did just that. The bad news is that it's a lot of work. The good news is that it works. But here's my disclaimer: "Kids, don't try this at home." No kidding, I just played around with this and got it to work - doesn't mean it will work for you. AND, you need to know how to play around with WORD tables. AND, I'm using the Access version. Don't know if the plain version uses Access tables. AND it takes a few hours if you have a lot of sources to review. But if you do have a lot, you don't want to type them in, right?. If you read a few lines and feel lost, this isn't for you. Virginia [email protected] - ------------------------------------------------- Remember, I said it was tricky (and maybe dangerous), but it worked for me. I tried it on a Test database first, just in case. Don't call Liz, since I'm sure she doesn't sanction this (but maybe she will add an easier way to do this, when she sees how desperate some of us are). So here goes: -Get your source data out of your genealogy program or wherever and into a WORD doc file, preferably with tabs between fields (less work than commas, cause you want to keep the commas that appear within your data). I ran a Source Report in Generations (Reunion). -Look at your data and make sure that the columns of similar data will line up, adding extra tabs for blank fields, etc. Don't worry about what the columns are right now. Just get them lined up. -Select the data and click on Table, Convert Text to Table. If you get too many columns or too much data is in the wrong column, reverse it by clicking on Table Select Table, then Table Convert Table to Text. I think it's easier to fix it when not in a table. Go back and forth between Text and Table until all your data lines up. -Open your database in Access and open tblTitle. Copy the header row and paste it into your WORD document at the top, but not in your source data table. -Add a header row to your source data table, and name your columns with similar names to what is in the tblTitle header. (Loc is the city and state of the publisher and Address is the address of the Repository. I think all the other headers are clear, except RepositoryID, which we will get to.) -Move your data columns around until they are in the same order as the tblTitle header, adding blank columns where necessary. (Use WORD Help for Tables, if you don't know how to do this.) -Sort your table by Repository (hoId the cursor over the top of the Repository column until it changes into a down arrow and click. Select Table Sort) I don't know this for sure, but I think you have to have something in this column. Clooz has 'Not Available' in this field when you first enter a source in Clooz, so add 'Not Available' (no quotes) to any blank Repository fields. -Go back to Access and open tblRepository. You will see two columns, one is RepositoryID and the other is Repository. Note the repositories that you have already entered into Clooz. Look at your source data table and if you find any repositories that match those in Clooz, enter that RepositoryID into your source data table in the RepositoryID field. Make sure that the spelling and punctuation are exactly the same as what you see in tblRepository. -Note the highest RepositoryID in tblRepository. Start numbering your data table by assigning the next higher number to one of your new repositories. For example, if tblRepository goes from 0 to 10, then assign 11 to one of your repositories that is not in tblRepository. Every occurrence of that same repository should get this same number. -Now create a new table (in this same file) that consists of two columns, RepositoryID and Repository, by copying those columns from your data table. Sort this repository table by RepositoryID. Remove any rows that have repositories that are already in Clooz and remove any duplicate rows. There should be one row for each NEW repository (from the previous example, those starting with 11) and only one row for each RepositoryID. -Copy the data from this repository table you have created, and paste it into tblRepository right after the highest number (where it says Autonum). -Now remove the header row from your source data table, copy the data and paste it into tblTitle. -THAT'S ALL THERE IS TO IT. (ha, ha) -If you get an error when pasting into these tbl's, Access will give you a nasty message and create a table called Error something or other. Fix your mistake, take note of any rows that did get added and adjust your data accordingly. You can delete this Error table. I got this the first time I tried to paste my sources, because I didn't know that tblRepository had to contain the numbers first. -GOOD LUCK