ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I receive daily lists, and I need to automatically process them (https://www.excelbanter.com/excel-discussion-misc-queries/163747-i-receive-daily-lists-i-need-automatically-process-them.html)

ds_rousseau

I receive daily lists, and I need to automatically process them
 
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?

Kevin B

I receive daily lists, and I need to automatically process them
 
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 Backmann


"ds_rousseau" wrote:

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?


ds_rousseau

I receive daily lists, and I need to automatically process the
 
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.


"Kevin B" wrote:

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 Backmann


"ds_rousseau" wrote:

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?



All times are GMT +1. The time now is 11:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com