My Problem

Allan320 · June 26th, 2006, 09:57 AM

I have a task to complete for work. The user enters the data into a PDF file, which puts the data into an Excel Spread sheet. I have been tasked to use the data to create a CSV file that can be read into our main system which used Microsoft Access as its front.

What is the best method to tackle this. I already have my MS Access gathering and outputting a csv file, just not my excel. I would want to click a button within the main system that imported the data into the system.

Sorry if this is muddled, im witing it as it comes into my head :D

Thanks

Allan

jrogers · June 26th, 2006, 04:02 PM

if your main system is MS access, why do you want to produce the csv file from excel?

Allan320 · June 27th, 2006, 02:51 AM

I have a calculator that the results are passed into a Excel workbook. I want to produce a csv from this to be passed into Access

jrogers · June 27th, 2006, 08:31 AM

I presume it is not as simple as going to the worksheet with data on it and saving as CSV.. Otherwise you can do it in code by

Code:

    Dim objwkbook As Workbook

    Set objwkbook = Workbooks.Add

    Cells(1, 1).Value = 26     'Enter your data here
    Cells(1, 2).Value = "blue" 'Enter your data here

    objwkbook.SaveAs "test", xlCSV

hope this helps, if not can you give me some more details