I receive daily lists, and I need to automatically process them

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My csv supplier sends me hundreds of the lists. I have to then manualy
reorganize his lists into my excel sheet to import into my database.
this process is manual and I need to create some type of template that can
process my suppliers list, and automatically provide me with a new list,
ready to import into my database.

any ideas?
 
Can't you import the data directly into the database file and bypass the
middleman. It sure sounds like you're doing extra work here.
 
kevin thanks for replying.

But I can't do that because I still have to run functions on the table and I
only upload to the database once the table is organized.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting information from one excel file into another? 1
Potential CSV/Excel Conversion Issues? 2
returning a list of data and only including in the chart if choose 2
Access Importing csv daily files into access 2007 1
VBA Assistance Needed 5
I get a Format error when converting my yahoo contacts to CSV file 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
Compare 2 lists / conduct gap analysis (XL 2007) 5

Back
Top