Database importing and designing (Could use some Help)

[dias.roy06]

Good Morning:


I am designing a database and very new at access. I have imported a pretemplete from access and now tring to import data from a excell file into access and not really sure where to start. Can be a little fustrating where I am a novice at this at the same time very eager to learn from someone who is knowleageable in this.

Thank you

[dias.roy06]

My email is dias.roy06@gmail.com

[June7]

Can start with the Access import/link wizard.

If the Excel file needs to be normalized into multiple tables, need to first identify the data elements how they relate. What is the data in the Excel file?

[ranman256]

Note: If you plan on repeating this over and over...I use this method:
1. save the excel file to a generic name.
2. link the excel file as a table
3. a query to import the excel file...ie. qaImportXL.
Now every time you get a new Excel file...1. over write the generic filename, 2. run import query. Done.

[ItsMe]

Note: If you plan on repeating this over and over...I use this method:
1. save the excel file to a generic name.
2. link the excel file as a table...

Why would you link to a file when you could just use VBA to call a saved import procedure? Doesn't linking create write issues to the Excel file?