marstev
Last Activity: Oct 11 '15, 12:18 AM
Joined: Aug 20 '15
Location:
-
I have been using the append query approach to this, and it has been working well, producing the desired results. One issue I run into is that it creates duplicate entries every time I run it, so i delete all the old entries in the table first. Would I have been better served to crete a make table query? What is the difference between the two? How would I avoid duplicate entries in the new table? -
Thank you for that quick reply! Seems simple enough, I will try that out in the morning when I return to work. Hopefully, this does not get too complicated. Being new to databases, I don't want to get lost in my first project.
I do already have a separate table set up within my database for this import from Excel, and I previously tried just manipulating the data prior to import using the Text-to-Columns feature in Excel. This presented...Leave a comment:
-
Link query expressions to tables
I am importing an Excel file into my database, but the columns do not match my fields. My database tables have separate "Name" and "EmployeeNumber " fields, while the excel file combines the two as "Name - EmployeeNumber" .
Example: Following a direct import from an Excel file to Access, I am splitting out the Employee Number "C1234" from "John Smith - C1234" using an InStr query expression....
No activity results to display
Leave a comment: