var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Merge Access and Excel tables
Anyone has any ideas how to merge excel tables with access tables..
Heard some advice to write a script and sthg to do with ODBC as such.. but dun really noe the way to do it.. well.. im having trouble for it for three weekss... please help please help...
I cant do importing cos the excel spreadsheet is totally different frm the access table!! Arrr.. help me!!
Sometimes one field in access table is equivalent to 3fields in Excel table...
you could just link your excel table and then run an append query, but without knowing what you want to do i cant be of any more help
Your issue isn't technical, it's conceptual. What are the layouts of both tables?
Originally Posted by
Hi BlurBlur Girl
In responce to your PM asking what additional information needed
as teddy says what you need to do is provide us with table structure what relationships build up your data from your excel sheet maybe then we can build up some SQL that will let you do what you need to do i.e. an append query