Background:
For many years, I have used datasheets as an easy way to paste right from Excel into Access (SQL Server). Though, I have to always remove "." and "/" from the header row each time to make this work.
Question 1.:
Is there a way to get around having to clean "." and "/" from the header row and get it to paste?
Question 2:
Is there a better way of handling excel imports than this?
Thanks!
Best Regards,
Chris
For many years, I have used datasheets as an easy way to paste right from Excel into Access (SQL Server). Though, I have to always remove "." and "/" from the header row each time to make this work.
Question 1.:
Is there a way to get around having to clean "." and "/" from the header row and get it to paste?
Question 2:
Is there a better way of handling excel imports than this?
Thanks!
Best Regards,
Chris