Exporting data from excel in QuickBooks

[punter]

Hi,

I have several hundred lines of data each week that need to be entered
into QuickBooks. The data comes from an outside company that sends it
me in an excel spreadsheet. I want to build a macro or something that
will export the data out of excel into QuickBooks so I don't have to do
it manually.

Has anyone done this before? Can you let me know of any pitfalls there
might be, any websites that might help, ect.

Thanks


Eddie

 

[Lady Layla]

Start with it from Quickbooks side -- can Quickbooks handle import of data, how
does the data need to be set up? Check Quickbooks groups and website to start




: Hi,
:
: I have several hundred lines of data each week that need to be entered
: into QuickBooks. The data comes from an outside company that sends it
: me in an excel spreadsheet. I want to build a macro or something that
: will export the data out of excel into QuickBooks so I don't have to do
: it manually.
:
: Has anyone done this before? Can you let me know of any pitfalls there
: might be, any websites that might help, ect.
:
: Thanks
:
:
: Eddie
:
:
: ---
:
:

 

[tommyboy]

This is possible to import data into quickbooks via a csv file, go t
quickbooks help and searcg for import transaction, this will show yo
the format for importing


let me know if u r still having problem