[RESOLVED] Access import help needed!

[patweb]

I am trying to create a procedure to import price files from Excel into an access database.

However, the stock codes contain alpha, and numeric characters.

Also, if the first stock code is a raw number, Access will ONLY import stock codes that are numbers (anything with text is dropped).

If the first stock code has letters, then it will import the stock codes with letters but automatically converts all numbers over 10000000000 into scientific notation.

The receiving table is set up with that column as text.

Any help?

[patweb]

I was able to get the import to work by changing the receiving tables StockCode field to a memo field, however, I need to figure out a way to toggle this back to a text field after the import. Anyone?

[Topsie3v]

Hi
Would it not be easier to make up a data base in Design view and then copy and paste the entries in that way you could choose the format for each column. I have done it once can't remember though if I had any problems to overcome at the time. Bit its worth a go.

[patweb]

Thanks for responding.

What I came up with was doing a Paste Append on the table in access. What I wanted to avoid was creating a new table or deleting tables to streamline the procedure.

I made a nifty macro that deletes all records in the table, then opens the table so that all you have to do is a Paste Append.

Now I need to figure out a way to filter a report based on a drop down menu that lists all of the suppliers . Basically, we have a huge inventory file, and I want to have forms and reports that the user can select the supplier to filter a query attached to a form or report.

If anyone can help with that, it would be much appreciated.

the table is Suppliers, and there are two fields "Supplier" and "SupplierName". I got the form and the drop down already, but I need to know how to push the selection into a query.

Thanks again . Pat