Import from Excel

[Privateer]

I am importing one large field from Excel, a string between 300 and 600 characters long and delimited by a semi-colon, which does not exist in the data, so I get the whole enchilada. Additionally, because of the length, I changed the field type to memo, from the default text. All of this is saved in a specification file on my machine. But someone else in the office will be using this DB for work. Now I can create the spec file on that machine, so it's not a big deal, but it raises the question about how to handle this issue programmatically? Does anyone know of a way to code a spec file for importation? The importation wizard does a pretty good job, but I would like to handle that myself. Thanks.

 

[Ranman256]

The spec file is in Access, not on the PC.
no need to rebuild it.

 

[Privateer]

Thanks, found it in the hidden MSysIMEXSpecs table. Always thought it was buried in some deep dark system folder ini file somewhere. Makes my life easier, thanks again.