Add more data to the database

[David_Skov]

Well I thought I knew, but it doesn't seem to work. I have data that I enter into excel, and then I import it into Access. I then used the same excel sheet and entered new data. Then I wanted to import that data into Access, but it says it contains errors. So I don't know what to do now

I use the 'Get external data' -> 'Import' function. Is there another way? Can I post the errormessage in here and would that help?

It just says an error occured but not what type of error

 

[SydneyGeek]

Yeah, it's driven me nuts one or twice...
My preferred option is the one listed in this post -- http://www.mrexcel.com/board2/viewtopic.php?t=103912

Denis

 

[bat17]

usualy the problem is that Access is not getting the data in a format it expects, say a date field in access but text in excel.
Are you adding it straight to an existing table or creating a new one? if adding try creating a new one so that you can compare the new to the old.

HTh

Peter

 

[David_Skov]

So even though the format in access is as it should be, then the excel has to be the same too?

I will try to compare, seems like a good idea

usualy the problem is that Access is not getting the data in a format it expects, say a date field in access but text in excel.
Are you adding it straight to an existing table or creating a new one? if adding try creating a new one so that you can compare the new to the old.

HTh

Peter

 

[David_Skov]

It doesn't work, that ****. It doiesn't even give me a reason. Only says it encountered an error!. Really cleaver program

I get the data from the exact same Excel file. I only copy new data into the excel sheet and to keep the format I paste only values.

I start by making database for 2002 by importing data from the excel sheet. Then I copy new data into the excel sheet I just used and choose 'get external data' -> import

Then I go through the wizard and choose to import into the database with 2002 data. When I choose finish it says it encounted an error occured trying to import the file bla bla this is so strange

Any suggestions?

 

[bat17]

one possibility is to save the file as a CSV file as the text import wizard in Access gives you more control over what is happening then.

Peter

 

[bat17]

Another thought, rather than copying your data to Excel and importing it have you tried pasting it directly into Access?

Peter

 

[David_Skov]

Another thought, rather than copying your data to Excel and importing it have you tried pasting it directly into Access?

Peter

can I do that?

I'll try both suggestions

 

[bat17]

If you copy the data and just paste it in to the dtabase Access will ask if it has headers and then create a new table with it.
If you copy it without headers and select the empty row at the bottom of your table you can paste it directley into the table (Assuming fields are right!)

Peter

 

[David_Skov]

Wohooo that worked! :D

Tx very much now I have exactly what I need

If you copy the data and just paste it in to the dtabase Access will ask if it has headers and then create a new table with it.
If you copy it without headers and select the empty row at the bottom of your table you can paste it directley into the table (Assuming fields are right!)

Peter