Datasheet view of a form when the record souce changes.

[grmman]

I have a weird problem.
I am importing in data from excel spreadsheets. and I want to be able to display the data to the use in a datasheet view form, my problem is the struct of that data changes from one spreadsheet to another.
So is there a way to create a form on the fly and the currect record source to be the new table I imported.

Thanks for any help you can give me.

 

[grmman]

NO need for help I got this to work.