Import data specs... form

[Hdata]

Hello and thanks for taking this question

I have multiple tables of data in my access file that I have imported from an on-line source. I have also previously formatted each field (ex: long integer, Short date, text w/50 characters), within my tables to match queries I use repeatedly.

So, I believe I'm looking for an access function (or vba code) that would read and list the field names with data types of my existing tables, so I can use this info in my Import Specs form and save for future use.

Once again, thanks for your help!

 

[sxschech]

Have you tried the database documenter? Under Database Tools Database Documenter. Or do you need a programatic list to store in a table?

 

[isladogs]

Run the import again manually and at the end SAVE the import specs when prompted.
You can then use those specs to automate the process