Data Import

Hi all, I have a series of Word pages, that make up a book of verbs.

The client would like these made into a dictionary database.

Each page has similarities but they are not identical.

Each page has one verb and all of its conjugations.

I can get the pages into html and Excel.

I have a database structure. The question is how to import the data.

At worst, I can copy and paste :frowning:

I would appreciate any ideas on how to better accomplish this task.

without seeing any details, there is very little anyone can to do help you

excel files import very easily, although the mechanism varies by database system

however, this presupposes that you have created the excel file with the express purpose of importing into a database table, which means no blank columns, everything must fit into specific table columns logically

Hi Rudy, I am posting a few lines of the spreadsheet below. I guess I could massage the spreadsheet as per your advice… It’s a toss up between dealing with a 300 page spreadsheet and copy and pasting directly into sql tables, unless there is a more sophisticated method…

Thanks for helping.

P. S. 	I discovered, invented				I was discovered, invented			
	ανακάλυψα		ανακαλύψαμε		ανακαλύφθηκα		ανακαλυφθήκαμε	
	ανακάλυψες		ανακαλύψατε		ανακαλύφθηκες		ανακαλυφθήκατε	
	ανακάλυψε		ανακάλυψαν		ανακαλύφθηκε		ανακαλύφθηκαν	
F. C. 	I will be discovering, inventing			I will be being discovered, invented				
	θα ανακαλύπτω					θα ανακαλύπτομαι		
	θα ανακαλύπτεις   	etc.			θα ανακαλύπτεσαι	etc.		
F. S. 	I will discover, invent				I will be discovered, invented			
	θα ανακαλύψω		θα ανακαλύψουμε	θα ανακαλυφθώ		θα ανακαλυφθούμε		
	θα ανακαλύψεις    	θα ανακαλύψετε	θα ανακαλυφθείς	θα ανακαλυφθείτε				
	θα ανακαλύψει      	θα ανακαλύψουν	θα ανακαλυφθεί		θα ανακαλυφθούν 			
Pr. P.	I have discovered, invented			I have been discovered, invented				
	έχω ανακαλύψει				έχω ανακαλυφθεί 			
	έχεις ανακαλύψει 	etc.			έχεις ανακαλυφθεί	etc.		
P. P. 	I had discovered, invented			I had been discovered, invented				
	είχα ανακαλύψει				είχα ανακαλυφθεί 			
	είχες ανακαλύψει  	etc.			είχες ανακαλυφθεί  	etc. 		
F. P.	Ι will have discovered, invented		I will have been discovered, invented					
	θα έχω ανακαλύψει 	etc.			θα έχω ανακαλυφθεί 	etc.		
				   	Subjunctive 	(with να, για να, όταν, etc.)		
P. 	να ανακαλύπτω 	that I may discover    	να ανακαλύπτομαι      that I may be discovered					
P. S. 	να ανακαλύψω 		that I might discover	να ανακαλυφθώ          that I might be discovered				
P. P. 	να έχω ανακαλύψει 	that I may have 		να έχω ανακαλυφθεί 	that I may have been 			
P. 	ανακάλυπτε (sing.) 	be discovering		-				
	ανακαλύπτετε (pl.)	be discovering		-				
P. S. 	ανακάλυψε (sing.) 	discover		ανακαλύψου (sing.) 	be discovered			
	ανακαλύψετε (pl.) 	discover		ανακαλυφτείτε (pl.) 	be discovered			
	να ανακαλύψει 		to discover		να ανακαλυφθεί 	to be discovered		
	ανακαλύπτοντας 	discovering		ανακαλυφθ-είς, -είσα, -έν      discovered				

yeah, you would have to seriously massage that before it is import-worthy

  1. no blank cells

  2. everything in a column must come from the same domain, i.e. be the “same type” of data

What do you mean by same type of data? strings? text?


you appear to have the english term and its various definitions in the same column

but those would be different columns in the table, no?

like, you could have an excel sheet with author on one row and the author’s books on subsequent rows, and you could have the author’s name “share” the same column as the book’s title – but they would be different columns in the table

thus you have to semantically “untangle” them (distinguish between data domains) before loading

Got it… Thank you Sir.

If you think of automated ways to handle this, let me know :slight_smile: