Problem with Import Specifications

[Calvin Dent]

Hey Guys,

I'm trying to set up a Macro to Transfer Text into a created table.
Because the table has no headers I'm using an Import Specification to do it.

Unfortunately, The Macro dropdown for "Specification" isn't finding my Import Spec.... Its only finding a specification labeled "1" which I never made...

Anyone know whats going on here?

[TheSmileyCoder]

Most of the people here use VBA instead of macros as it gives a much higher degree of flexibility and control. That includes me, so I have little experience in macros, but since noone else has answered I will give it a go anyway.

I suggest:
Either try to save your import spec once more, and see if it becomes available, or try to use the 1, importspec and see if that is actually what you have saved.

It could be a simple matter (bug) of the developers that they listed the KEY column instead of the name column in the interface.

[Calvin Dent]

Hey, Sorry I didn't reply here sooner.

I realised pretty quickly that actually it was my own fault it wasn't working, I was saving the Import Steps not the Specification... Making me an idiot.

I'm using VBA Functions right now and Macro's to Automate some functions when the Database loads by use of Autoexec.

Thanks for the help.

[TheSmileyCoder]

As long as one is learning, there can be no idiot.

I just thought I would ad a note on the startup thing. If I want for something to run at startup, I attach it to a forms load event, and set that form to be opened at startup. I can set its visibility property to false, so that the standard user does not see it.

[Calvin Dent]

Its not actually going to be used to input Data.

What I'm using it for would probably suit excel a little more.

When the Database is opened it deletes a table then imports a CSV file into the deleted table, Queries the data and assigns a value based on criteria then creates a new table based on it.
It then sums up the data and returns a summary.