I'm Back...Sorry it took so long to reply have been busy with other things. I tried the above and got a "Syntax Error in insert into statement".
If it helps any here is a shot of the DB.
and a shot of the excel file I'm importing and trying to insert into the table.
msag is the name of...
I have several backups in different places.
I have many dupes already because some streets go in and out of the city limits so their is and entry for each time that happens with an address range.
_______
I.E.
Smith St| 100 - 200
Smith St| 250 - 300
Smith St| 375 - 800
__________________
One...
Hi,
First I want to apologize for not searching for the answer but I am not knowledgeable enough to do a proper search so forgive my forum etiquette fopah.
I have a simple Access DB with one table and 8 columns and just shy of 3800 records.
I have imported a coma delimited file into a second...