Importing Data

B

B

I have created an Excel spread sheet which is connected via ODBC to Microsoft
Access database.

I then run a macro to update my spreadsheet when ever data is added to my
database.

When the spreadsheet is updated the new data appears a count i.e. a column
of 1's and not the data I want.

I then have to go into field sttings and change summarise by to : SUM

I dont want to have to go throught this all the time.

Ive tried all possible methods. Why is this happening and how can it be
resolved

Thanks in advance for any advice is recieve.
 

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

Embed the same Excel multiple times 0
Importing Data Using ODBC Connection 1
add mergefields to exsting word 2013 2
Importing data from Excel into Access 1
Excel Import / Referential Integrity Question 8
split data base using ODBC connection 1
Import data from excel 1
Import data and update changed information 1

Top