Using table as template or such

[blor]

Please be patient with me, I am new to access ~ so far it is winning.

I am creating a table from an imported excel sheet.
After many many many times of attempting to get access to accept the data, I think I am about there, my hope is that since my excel sheets will be exactly the same every month, is there a way that once I get the table done I can just import the next months data and not have to go thru setting all the fields again?

again, I am new ~ please explain in simple terms as to how to do this. I have the MS step by step (don't recommend it) and access to mastering access book, but I am sure someone out there can explain it better than this book is doing.

This was suppose to be done almost 2 mos. ago. Any help is most appreciated

 

[Wocca]

You have two options

1. Intead of importing the XL you can link to it. Then when the new SS come in you can rename it to the linked name & that will be available in Access. It would probably be best to have a query to move the data from the linked XL SS to a native access table as although you can do some manipulation of the data it can be a bit awkward. i.e. Month 1: Receive XL file called XLFile, rename as XLFile1, link to Access DB, run query to take data from linked XLFile1 into native Access table. Month 2: Rename new XLFile as XLFile1 (deleting earlier version or saving it elsewhere) & then run query again.
2. Whilst importing XXXXX correction. When importing txt files you have the option of saving an import specification but I just checked & Access (2000 at least) doesn't allow this option for XL.

Hope this is of help. Regards
Warwick